Import from Excel to Access

[Guest]

I successfully imported an Excel file into a Access table (TEMPTBL). Now I
want to select certain fields from the (TEMPTBL) table and import them into
the PROJECTS table. Is this just simply a SELECT field1, field2, field3 FROM
TEMPTBL or is this an INSERT SQL statement. Any examples would be
appreciated. Yep, I am new and this is fun!!

 

[Guest]

Start by creating a new query in design view.
When you have the query builder open and the dialog to choose tables opens,
select your TEMPTBL.
Now select the fields you want to put into the PROJECTS table.
Now from the menu select query type and select Append. It will ask which
table you want to append to. Select your Projects table.
Now at the bottom of the query builder select the fields you want to populate.
run it.

 

[Peter Hibbs]

Have a look at the Excel to Access Converter Utility at:-
http://www.rogersaccesslibrary.com/...me='Excel to Access Converter Utility program'
which may help.

Peter Hibbs.