VBA Script w/in .mdb File to Create .xls File

[tfhwargt3]

I have a VBA script that is linked with an Access .mdb file that does several actions on the tables of the database. At the end of the script I want to output a lot of the data in the tables to excel files, and populate cells with Access Table data. The problem is, I want to import tab delimited data AS AN Excel file, not Access, and then combine this data with the Access Table data to make one .xls file.

I was wondering if I have to have a separate VBA script window in Excel to do something like this, or can I output to excel from the Access VBA script?

 

[tfhwargt3]

Nevermind. I just realized I can create a temp table in access and just do a straight export to excel from that table.

Sorry to bother people with dumb posts.