Data Import Script from Excel to Access
Posted on 2011-03-01
Is there a way to build a script in access to import all the pages in a workbook, into separate tables in Access? For instance, the pages in Excel would be Sales, Inventory, Returns, Demand Forecast. Then import those pages into their respective tables, tblSales, tblInventory, tblReturns, tblDemand.
How do I do that without running 4 separate import processes? In actuality, the above example is just a sample of what would have to be completed each week. We actually have about 25 workbook pages going into Access.
Thank you! :0)