Excel Import into Access 2007
Posted on 2012-04-05
I need to export a spreadsheet sheet into a new Access Table. No problem doing so, when I manually run the import, the rows come into the table in the same order as the spreadsheet, which is exactly what I want. When I run this in a Macro using RunSavedImportExport, the import works fine, but the order of the data is different than in the original spreadsheet. This is a problem for me as I use the contents of the data in the first 3 rows to run a series of modules.
How do I keep the same order in the table as I had in the spreadsheet? I am not using any Keys or auto numbering?