Multiple table import?

  • Thread starter Thread starter Keith
  • Start date Start date
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.
 
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.
 
Back
Top