Javier, You describe the photo as an OLE object. That may indicate that the photo may not be stored in the database. OLE means "object linking and embedding". This could indicated a "pointer" to data located else where. I don't think RBase as a direct ODBC translation for OLE objects.
You may want to consult the following website http://www.ammara.com/articles/accesspictureole.html for a discussion of this subject. Jim Bentley --- Dan Goldberg <[EMAIL PROTECTED]> wrote: > 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 > > > Jim Bentley American Celiac Society [EMAIL PROTECTED] tel: 1-504-737-3293 ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
