Problem Importing From Excel

[Guest]

I'm trying to import a spreadsheet from excel (2000) into a new table in
Access(2000). The problem is, one column in the spreadsheet contains
hyphenated case numbers (i.e. 94-9030457). Since these were typed in by two
different people, some of the numbers were typed in with the hyphen and some
do not contain the hyphen. When I try to import this sheet into an Access
table, I get a message saying there were errors in importing some of the rows
(the ones with the hyphens). I can't seem to specify what data type the new
field in the new access table will be as it is grayed out. Any ideas?

 

[Van T. Dinh]

When you import from Excel into Access, Access will check the first X rows
and automatically determines the data type for each column. The problem is
that Excel allows mixed columns and you will have import errors one way or
the other with an Excel mixed column.

My work-aroung is created a "calculated" Column in Excel using the
Spreadsheet function Text() to convert all values in the mixed Column to
Text. When I import into Access, I skip the mixed Column and import the
"calculated" Column where all values in the Column is of Text type.

Check Excel Help on the Text() function.

 

[Joan Wild]

I'm trying to import a spreadsheet from excel (2000) into a new table in
Access(2000). The problem is, one column in the spreadsheet contains
hyphenated case numbers (i.e. 94-9030457). Since these were typed in by
two
different people, some of the numbers were typed in with the hyphen and
some
do not contain the hyphen. When I try to import this sheet into an Access
table, I get a message saying there were errors in importing some of the
rows
(the ones with the hyphens). I can't seem to specify what data type the
new
field in the new access table will be as it is grayed out. Any ideas?

I believe it uses the first 25 rows of the Excel sheet to determine the
datatype. It will then report errors that don't conform to the datatype.

Could you move a row with a hyphenated case number to the top of the
worksheet?