How do I open a spreadsheet in access and save as database?

[teridayton]

i am having a problem opening several excel spreadsheets in access and saving
in access. I am telling it to import data and it is linking to external data
source. none of my info is saved in access and my ability to manipulate it is
limited. Any ideas???

 

[Klatuu]

Obviously, you are linking rather than importing. That is okay. You can
either change your code to import rather than link or, my preferred approach
is to link to the spreadsheet, then use an append query to move the data into
an Access table where I have full control over it.