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

[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

 

[Tom Ogilvy]

See Mr. Erlandsen's site for sample code:


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

 

[Chris Dunigan]

Thanks Tom,

That works brilliantly!!



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