Import failure, Column limit?

[steallan]

Hi
I am using the New table: Import table function. Howwever after i go through the wizard/settings bit if fails to import. Is this because there is a limit to the number of columns i can have in a table? Im trying to import a excel sheet with 56 columns. When i reduce the number of columns it does import.
Is there a limit or should i keep looking for some other error?

 

[Cbrine]

You should be able to import up to 256 columns worth of data in excel, so the problem must be caused by something else.

HTH
Calvin

 

[steallan]

ARRRR!
Thanks mate back to tearing my hair out

 

[steallan]

Well this is strange can anyone tell me why this is the case.
Import would not allow these as column titles
TE003 SUPPLY AIR TEMP SENSOR
TE004 EXTRACT AIR TEMP SENSOR
It renamed them field50 and field 51 but then came back with an error cant import table when i clicked finish.
So i changed them to these:
TE 003 SUPPLY AIR TEMP SENSOR
TE 004 EXTRACT AIR TEMP SENSOR
And it worked fine, whats the problem with TE003 and TE004 that access doesn't like?

 

[steallan]

NOOO!
I spoke to soon it still wont import the table. Could anyone please tell me What are common reasons why tables wont import (i get An Error occured when trying to import table etc message when i click finsh)
stupid access

 

[Cbrine]

Access is very tempremental when it comes to imported column headings. I would suggest you either import it without titles, and then manually adjust them, or create a table with headings already, and dump the data without titles to a raw data file, and use a Delete, then an update query to update the table with the headings already set.

HTH
Cal

 

[Andrew Fergus]

Following on from Cal, there might be something in either this article or this article from Microsoft that might help.

Andrew.

 

[Norie]

Could anyone please tell me What are common reasons why tables wont import

One of the most common errors occurs when the data being imported is inconsistent.

Access looks at the first 20 or so rows of data to determine the data type for the field.

If there are any anomalies, eg text in a column that Access thinks is a number, it can cause problems.

Another problem could be the field names - are there any duplicates, any leading spaces?

 

[steallan]

thx all