Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Importing excel cells to more than 1 access tables
Yes, every table has a ClientID field. When the client's data gets imported from the spreadsheet, a new clientid has to be created and then the tables get related by that ClientID.- thadson
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Importing excel cells to more than 1 access tables
Thanks for the answer SkipVought. Will this code make sure that the data from the spreadsheet will remain together in the database. What I mean is that for example -from the above example - let say that Table1 would contain first middle last names of a client. Then table 2 is address city state...- thadson
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Importing excel cells to more than 1 access tables
Hi, I'm trying to import specific cells from about 500 MS Excel 2000 spreadsheets into MS Access 2000 tables then move the spreadsheets to a different directory. I'm very new to this and I'm having trouble to implement this. I have worked out so far the code to import certain cells into 1...- thadson
- Thread
- Replies: 5
- Forum: Microsoft: Access Modules (VBA Coding)
