Importing from an excel sheet

J

Jon

MS Access 2003

I'm trying to import an excel sheet which contains embedded OLE objects as
one of the columns (named Attachments).

Using the Import Wizard it is noted that the data type for the
'Attachments', as for the other columns cannot be changed.

Basically these consist of word documents, which provide further
descriptions to the textual summaries within the excel sheet.

The problem is that the import wizard seems to ignore the contents of these
cells.

Is it possible to retrieve the OLE objects in batch somehow?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top