Importing excel and word files

[Gurn]

Is there a way to import a file as a whole into a database? I can not find anything but importing the data from a file... Help Please!!!!
gurn

 

[The_Doc_Man]

Is there a way to import a file as a whole into a database? I can not find anything but importing the data from a file... Help Please!!!!
gurn

You really don't want to do that. It is a good way to fill up databases so fast that they become useless.

Are you sure you don't want to import a reference to a file?

Another thought: Access works on Access files. Your subtitle talks about importing Excel and Word files. If the file you wanted to import isn't an Access file, why do you think it would make sense for Access to contain the file? Access isn't a file system. FAT, FAT32, and NTFS are file systems. Access is a database that has its own internal format. Why do you want a file of foreign format inside your Access file?*

*Rhetorical question.... you DON'T want that. Despite whatever idea got you thinking this way.

 

[Lister]

If you want the user to open and Excel or Word document for what ever reason you have, from Access. You could link the document with a hyperlink, just point the link to the file location.
Create a label is the simplest way and in properties use the Hyperlink Address property to create the path to the document you want the user to open.

This would be preferable on a local drive or a network drive.

The Doc is correct, don’t bloat you database with embedded files if you don’t have to.

Hope this helps.

 

[Gurn]

Thanks the Hyperlink works great!!!!