Data Import - Excel to Access

[kacey8]

Hi,

So I have a new DB set up, tested and working and we're happy with it.

However I am having difficulties importing from excel into the existing table and choosing the fields to import into, I have 7 excel spread sheets to into in to the one, each with around 5,000 entries.

When I try to import it keeps trying to add new fields, but the fields I want are there. How can I get it to let me match Column A with the field which matches this?

 

[kacey8]

Thanks, so simple.. worked perfectly


However, on a side issue I now have.

Some data can not be imported due to a "Conversion Error" all the numbers from that column get imported but anything with letters isn't imported.

The field it is going into is set to "short text" which is more than enough limit to allow the words.

Any suggestions? the previous Import (spreadsheet 1 went fine) but this one is being picky

 

[kacey8]

That's the thing, as far as I can tell they're both set to "General"

http://s25.postimg.org/i4e006skf/excel.png
http://s25.postimg.org/p6bxmdw67/Untitled.png


Top link is the excel, showing it's set to general.

Bottom is the field set up in Access

Problem is, this never happened with the previous import which contained similar data

 

[kacey8]

I also just tried it into a fresh clean DB, let it create it's own fields into a new table and once again, same import errors.

 

[JHB]

Some data can not be imported due to a "Conversion Error" all the numbers from that column get imported but anything with letters isn't imported.

Is MS-Access not creating a table with the data that have the "Conversion Error"?

 

[kacey8]

It does create an import error with three fields, it gives me

"Conversion Error", "Field name" and "Imported Row number" no other details.

 

[kacey8]

So I found this on Google

"Access looks at the first row(s) to determine what the rest of the column contains. If it sees all numbers, it will import it as a number. If any subsequent rows are text, the import will fail on those records."



ETA: Did this moved one with mixed text/numbers and it worked perfectly.

 

[JHB]

It does create an import error with three fields, it gives me

"Conversion Error", "Field name" and "Imported Row number" no other details.

Yeah and it should be details enough to do some investigation!
But anyway you've solved the problem, so everything is fine.