-
Link Excel into Access
I have several spreadsheets that are identical except for the data in the cells. Does anyone know how I can link the same sheet from all the spreadsheets into one table in access without manually coying the data into the table one at a time?
Thanks in advance
Scadadude
-
You can link your spreadsheets to Access and then use an Append query to pull the data from the linked table into an exisitng Access table.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules