![]() ![]() If you are creating the table from a SQL statement, the data type is IMAGE (similar to SQL Server). Microsoft Access stores BLOB data in the a field with an OLE Object data type (if you are creating the table from Design View). When you download, you must also select the file that you want to download from the listview. This field is used for the file that you want to upload and for the file that you want to download. ![]() When you use the application, the text box for the Data File contains the full path name to the file on your disk. The sample application comes with a Microsoft Access 2000 database. The sample application included with this article is just used to illustrate how to upload and download BLOB data to a Microsoft Access database. There are many code snippets on the web for uploading and downloading BLOBs to SQL Server, but I could not find anything for Microsoft Access. A BLOB may be an image file, a spreadsheet, a word processor file, etc. The simplest way of describing a BLOB is as a file stored in a field in a relational database. AccessBlob illustrates how to upload and download Binary Large OBjects (BLOB) to a Microsoft Access database. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |