Need help Importing data from excel

[hibbii]

I am trying to import data from a spreadsheet into a pre-created table. The table however has columns that the spreasheet does not such as an autonumber PK and an ID as the FK.

What is the best way to get start importing into column 3 of the table from the spreadsheet and keep the first 2 columns intact.

The other problem I have is when I try to import some calculated fields from excel I get #NUM! in the table.

Any help would be appreciated.

[NeoPa]

Your first question doesn't seem very clear, can you remember what it means?
As for the second, is the #NUM data already in the Exel spreadsheet? I suspect it is.
Tidy up your Excel data first then you could try 'Linking' the spreadsheet instead of importing it.
That way you could merge it in intelligently using an action query.

[Fotorat]

I think I know what you mean, to start importing from into the 3rd access tbl field you could simply insert to blank columns into the excel sheet so column A and B are blank.

the second problem you have in your formula cells in excel is that you are actually pasting in the formula text not the result of the formula. you can get around this in excel by highligthing the whole sheet and doing copy> paste special > values. warning> this will over write your formulas with the results, but will import ok

Tony

[PEB]

Ehe NeoPa you see... the sample Copy /Paste sometimes is more powerfull than the programming tools that we use ;)

Only Hide the columns that you don't ned to populate with info and the other will follow...

:)

And I think our language is sometimes a bit sofisticated for begginers...

But we think that everybody wants to do the things programatically :)

Best regards..

[MMcCarthy]

I am trying to import data from a spreadsheet into a pre-created table. The table however has columns that the spreasheet does not such as an autonumber PK and an ID as the FK.

What is the best way to get start importing into column 3 of the table from the spreadsheet and keep the first 2 columns intact.

The other problem I have is when I try to import some calculated fields from excel I get #NUM! in the table.

Any help would be appreciated.

As NeoPa said, link the spreadsheet rather than importing it.

Now use an update query to add your data to the table if the records already exist (you will need some field value in common) or an append query to add new data to your table.