I have existing information in Excel that I'd like to import into Access. During database design it was determined that the flat-file should be setup as a main table and a couple subset tables. There are five columns in Excel that are used for salary or hourly information. They weren't split into separate columns, they were just left in the same five columns to prevent folks from having to scroll all over the place; when you're looking at the spreadsheet, you can tell who is what. It ain't pretty, but it is efficient.
Anyway, is this possible to do automatically? Can I start an import into Access and then start splitting out the information into different tables? Shoot, I'd be happy if I could do it manually, putting the information into one big import table and then performing append queries into the other tables. What I'm not sure how to do is a conditional append query. If a record is indicated as being a salaried employee, then import into tableX; if the next employee is not, then don't import, etc. How would I ensure that the primary key, which happens to be Autonumber and not EmployeeID, is the same between the main table and the subset table?
So, with a macro or VBA, can I start running append queries?
Lots of questions, whatever you can answer will help!
Thanks in advance!
Onwards,
Q-
Anyway, is this possible to do automatically? Can I start an import into Access and then start splitting out the information into different tables? Shoot, I'd be happy if I could do it manually, putting the information into one big import table and then performing append queries into the other tables. What I'm not sure how to do is a conditional append query. If a record is indicated as being a salaried employee, then import into tableX; if the next employee is not, then don't import, etc. How would I ensure that the primary key, which happens to be Autonumber and not EmployeeID, is the same between the main table and the subset table?
So, with a macro or VBA, can I start running append queries?
Lots of questions, whatever you can answer will help!
Thanks in advance!
Onwards,
Q-