You can do an export from Access using a macro. Then write a command file to import them in.
Dan Goldberg -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Javier Valencia Sent: Thursday, May 01, 2008 3:16 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Question on importing data from Access I have to import data from an Access database and a table that contains photos, and I am running into a problem that hopefully someone has the answer. I need to import a table that has photos. The table structure is: PhotographID Autonumber PhotoLocationID OLE Object When I open the table and look at the data, the second column is displayed as "Microsoft Word Document" There is a form in the database that actually displays the photos so, it appears as the photos are stored within the database and the database consists of just 1 large *.mdb file. I have attached the database via dsn-less connection and I can attach the table and then project it as a local table and the column PhotoLocationID comes in as a varbit and when I open the table using the browse command and place the cursor over the column, it show a large size but when I try to open, the viewer is empty. I have tried right clicking on the column on the browser and using the option "save as" and tied saving the data as a *.doc, *.jpg with no luck... Any words of wisdom??? Javier, Javier Valencia 913-915-3137
