Results 1 to 2 of 2
2004-10-11, 23:32 #1
- Join Date
- Feb 2002
- Summerville, South Carolina, USA
- Thanked 0 Times in 0 Posts
Excel data to different Access tables (Access 2000/XP)
We have an Exel for that offices use when requesting a file number from the corporate computer. The information on the Excel form eventually winds up in various Access tables mainly because of the relationships set up when designing the application. Is it possible to import this information into the Access table and the right Excel fields go into the right Access table fields without having to retype it in? I'm sure there must be a way, but I sure haven't seen any examples of importing data into multiple tables...single tables, yes. So, can someone point me in the right direction to see if I can incorporate this into the application?
2004-10-11, 23:49 #2
- Join Date
- Mar 2002
- Thanked 29 Times in 29 Posts
Re: Excel data to different Access tables (Access 2000/XP)
You can't import data from Excel directly into different tables, but you can link the Excel table in Access, and create a series of append queries based on the linked Excel table to add the data to various tables.