Import excel but selected column for selected table

  • Thread starter Thread starter EMILYTAN via AccessMonster.com
  • Start date Start date
E

EMILYTAN via AccessMonster.com

I want to import excel to access but I want selected column to appear in
selected table.
For example i want to be able to specify column 1,2,3 to load in table 1 and
column 4,5,8 to appear in table 2..
May i know the way please?
 
Suggestion,

Import to a temp table

Run 2 append queries appending the data to the files you want

Trev
 
May I know the way please?

Trever said:
Suggestion,

Import to a temp table

Run 2 append queries appending the data to the files you want

Trev
 
Go to File - Get External Data - Lnk and link to the worksheet. The fields
in the worksheet will appear as a table in your database. Create a query
based on that table and include columns 1, 2 and 3. Change the query to an
Append query and append to table 1. Create another query based on the table
and include columns 4, 5 and 8. Change the query to an append query and
append to table 2.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
Your way can work..
Do you other method where user can browse the excel file and then load it in
the table with selected field to appear?
I use TransferSpreadSheet but it show me external table is not in the correct
format...
 
Back
Top