Multiple table import?

K

Keith

I tried importing the Excel file into a new table. Then appending the new
table information into the rest of the database. But I can't get it to work
properly, there are five other tables with linked information that is
required. I can't figure out how to get the query to work.
 
G

Gina Whipp

Keith,

I believe you gave me the shortened version of what you are trying to do.
The below comment does not quite sync with your initial posting. Please
explain in detail the steps you are taking and what you are trying to
accomplish. Also provide the Access version. Also, are you trying to
actually import an Escel file or append a linked Excel file to an Access
table?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I tried importing the Excel file into a new table. Then appending the new
table information into the rest of the database. But I can't get it to work
properly, there are five other tables with linked information that is
required. I can't figure out how to get the query to work.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import Excel Workbook from Sharepoint 4
Add .csv File Name When Importing Multiple Files Into a Table 0
Importing into multiple linked tables 9
import xml not a problem, setting key for subtables is 1
how to import multiple Excel files into multiple Access tables? 9
Is it possible to import Excel sheet into multiple Access tables 6
Importing from Data Acquisition System ??? 2
Multiple excel files 3

Top