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

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

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

See Mr. Erlandsen's site for sample code:


http://www.erlandsendata.no/english/vba/adodao/

--
Regards,
Tom Ogilvy

"Chris Dunigan" wrote in message
om...
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

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

Thanks Tom,

That works brilliantly!!



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!