Importing from excel question

[STS4600]

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?

[jggtz]

Welcome to VB Forums !

Greetings,
---My thought would be to import the data into a preliminary table,...
Any suggestions?

If you need to do this only once, then...
Open your excel sheet
Select the desired rows
Control-C
Open Access
Create a new file & a new table
Control-V

If you need to do it several times then it would be better to write the correspondent code, it could be in excel or in access...
If you use ADO, then you can use a connection string special to open excel sheets

[STS4600]

We need to continuously add new data from excel to access. So this will not be a one time deal.

Do you know what code we would need to set a macro up in Access or Excel to have this automated?

[sapator]

Hi.
If you are going to program directly do access or excel with vba you better ask here:
http://www.vbforums.com/forumdisplay.php?f=37