import file to database

AST

Hi,
It is possible to import all kind of files (eg. pdf, excel,..) to database? I don't mean import path to file, but just file (as blob?).

Dave_Cintron

Yes, you can import anything, but to view it you will need to re-export and hyperlink to it.

Waldo

It's just the same as importing a .bmp into a blob.
With the MyTable.MyBlobField.EXPORT you can put it back to a file.
You should save the name and extension though if you want to reconstruct the file name.

garak

but note :!: If you have an SQL Datebase (equal native) it is not a good idea, to store the Files in the blob field. Its better to create a text field in the table and store there the UNC path.

Why? Because Navision, makes these kind of queries on sql.

select *, Datalength(YourBlobField) from TableXYZ ....

If you have there a lot of records in your table and these recs have big BLOBs, then the querries are not the fastest.

How to store UNC, see my post here

garak

if you import the file or the unc path to the file, open the file not with hyperlink, use WSH. Its better ;-)

see this post. Here the user can also use the open with function.

http://www.mibuso.com/forum/viewtopic.p ... light=open

AST

Thanks for all replaying