Excel to Access without linking

[newbiewonkinobie]

I want to import Excel into Access without linking the 2 together. I followed the directions on:

http://office.microsoft.com/en-us/assistance/HA010546501033.aspx

"Creating a new Access database from an Excel spreadsheet"

After opening the Excel file in Access with the import wizard (I can't find the import option), the access database shows the Excel icon indicating they are linked. How do I break this link because I will delete the Excel file after importing it correctly.

Flores

 

[PHV]

I can't find the import option
menu File -> External data -> Import ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Golom]

Just issue an SQL command

DROP TABLE myExcelTable

after you have finished processing it.

 

[newbiewonkinobie]

Thanks PHV, that was fast.

Flores