Is it possible to write vba to migrate data from excel into access?

[wedd]

Hi there, is there any vba code that can migrate data from an exel spreadsheet (i.e pivot tables and specifc data in cells from a worksheet), into a access report using vba code? If so, how can this be done? Would you have any examples of code to do this? I'm keen to increase the knowledge I have of vba...are there any websites which explain vba coding migration relationships between ms access and ms excel?


Thanks for your contributions:friends:

[L@ja]

hi,
start with the linked tbl's...
you can connect tbl to excel sheets...
then you can use this new tbl in query...
if data in the query then you can paint to any rep...

regards

[CreganTur]

DoCmd.TransferSpreadsheet

It has an import specification that you can use to pull the records from Excel into an existing or new table.

[wedd]

Thanks, Cregan Tur!

[CreganTur]

If your question is adequetly answered in any thread, please remember to mark that thread as solved by clicking Thread Tools -> Mark As Solved near the top of this page.