Exporting data directly from Excel to an un-opened Access database using VBA

  • Thread starter Thread starter Chris Dunigan
  • Start date Start date
C

Chris Dunigan

Hi everyone,

Would be really grateful if someone could tell me how to export the
entire contents of a worksheet into an existing (unopened) access
database.
The format of the data in the spreadsheet is identical to the dBase
set-up.

At the moment i am exporting as delimited text files and then using a
macro within access.

many thanks in advance,
chris
 
Back
Top