rmccafferty
Registered User.
- Local time
- Today, 14:08
- Joined
- Jul 20, 2009
- Messages
- 15
I need to append data from a spreadsheet (many spreadsheets over time) into an access table. There are several aspects of this I am not sure how to do.
First is that the spreadsheets have many tabs and within each tab are “tables” that contain the data. Thus, I believe that I need to designate named ranges for where to get data. And I believe the idea of linking to Access is out of the question considering the issue of multiple “tables’ within tabs in the spreadsheet. (And I really don’t want to think about linking and then unlinking tables via code. Maybe I just stated two problems, the idea of named ranges and the seeming unavailability of linking the tables to access.
Second, some of the “tables” in Excel have the field names vertically in a row with the data to the right. I have never tried to append data that was not in the traditional layout of field names spread horizontally in a row with the data below it. Is there a way to deal with that in the append query?
First is that the spreadsheets have many tabs and within each tab are “tables” that contain the data. Thus, I believe that I need to designate named ranges for where to get data. And I believe the idea of linking to Access is out of the question considering the issue of multiple “tables’ within tabs in the spreadsheet. (And I really don’t want to think about linking and then unlinking tables via code. Maybe I just stated two problems, the idea of named ranges and the seeming unavailability of linking the tables to access.
Second, some of the “tables” in Excel have the field names vertically in a row with the data to the right. I have never tried to append data that was not in the traditional layout of field names spread horizontally in a row with the data below it. Is there a way to deal with that in the append query?
