Excel to Access Tables

[Ruthless Artist]

Is there a module that can import data from and excel sheet into the tables
without getting duplicates?


Thanks.

 

[Arvin Meyer [MVP]]

No, because you need to decide what is duplicated. There is a Duplicates
Query Wizard that will help you find them after you import them. Just click
on the Query tab, then New, then look for the wizard and click on it.

 

[Ruthless Artist]

Im using a query to import the info to the tables i need some that will get
this info from the excel to access when it starts up.


Thanks

 

[Arvin Meyer [MVP]]

If the Excel spreadsheet is formatted with columns just like Access (IOW, no
spreading labels across colums) you can link it just like any other table
from any database. Choose File ... Get External Data ... Link, then change
the database type to Excel and say yes. The data will be linked and ready
for the query to work.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Ruthless Artist]

Thank you but I got it to do it upon the startup menu
I made the excel table a link then i made a new table and function import()
sql = ECT.......

Thanks.