Greetings,

I am trying to import data from an excel spreadsheet to access using VBA.

I already know that some of the data needs to be modified, and that I will need to import the data to different tables.

My thought would be to import the data into a preliminary table, and the move the data to the real table that will be used. From the preliminary table I want to manipulate the data and then delete out any unused fields.

Any suggestions?