import process converts text column to numeric!!

[Shivalee Gupta via AccessMonster.com]

i have an excel file called pat03 which i am importing using transferspreadsheet into access 2000. this table has like 30 columns. out of these, two columns have their first 50 rows as number. but after that there are text as well as number. but the import process has converted the column as number and not text...looking at the first 50 rows, maybe. and deleted the text entries!!
can anyone help me....please!
regards,
shiavlee

 

[Jeff Boyce]

Shivalee

I believe you asked a similar question before. The solution is still the
same.

Create a temporary Import table in Access that has its fields already
defined. Define those troublesome fields as text, not numbers.

When you do your import, import into the temporary Import table. Use
queries to further parse your import data into your final, permanent tables.

--
Good luck

Jeff Boyce
<Access MVP>

i have an excel file called pat03 which i am importing using

transferspreadsheet into access 2000. this table has like 30 columns. out of
these, two columns have their first 50 rows as number. but after that there
are text as well as number. but the import process has converted the column
as number and not text...looking at the first 50 rows, maybe. and deleted
the text entries!!