Jim: That was my first assumption, but I only got 1 *.mdb file and no other. I thought that maybe it was getting them from a remote server and I disconnected the computer from the network and I can still see the photos though the Access form. There is not much data in the database but the file is over 200 Mb, which tells me the data is stored internally. I will try the link. Thanks for the info.
Javier Valencia 913-915-3137 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of James Bentley Sent: Thursday, May 01, 2008 6:15 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Question on importing data from Access 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
