Exporting Access 2007 table to Excel

  • Thread starter Thread starter Fred
  • Start date Start date
F

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
 
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
Click to expand...

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
 
Back
Top