Exporting Access 2007 table to Excel

[Fred]

I am trying to use an Export function in my Access 2007 database so my users
can export their data. Using a Macro I can export to Excel and everything
works great, except one of my fields contains an attachment. A photo to be
specific and this data is lost during the export. Does anyone know of a
routine using VBA to export all the data in a table, including attachments,
then use another command to import this data, in tact complete with
attachments?

Thanks,

Fred

 

[alastair.ayliffe]

I am trying to use an Export function in myAccess2007 database so my users
can export their data. Using a Macro I can export toExceland everything
works great, except one of my fields contains an attachment. A photo to be
specific and this data is lost during the export. Does anyone know of a
routine usingVBAto export all the data in atable, including attachments,
then use another command to import this data, in tact complete with
attachments?

Thanks,

Fred

Hi Fred,

I'm sorry, i cant help you with your question (bit new to all of
this). I was wondering if you could post the code you use to export to
excel? I am having no luck with it.

Thanks

Alastair