coding text to column

[jnewl]

how do i code text to column in access vb?

i need to import an excel book and i need to make sure that the 1st column
is text.
the numberformat = "@" does not work, as it still gives me conversion errors
when importing

 

[Allen Browne]

1. Create the table the way you want it (with Text for the field field
type.)

2. Attached the Excel sheet (as a linked table.)

3. Execute an Append query to add the data to the table you set up.

 

[jnewl]

tried that and it does not work. built an access table where 1st field was
text.
did a link and a query. instead of conversion errors, got blanks in field 1
where there were alpha char in the field in the excel book

 

[Allen Browne]

Not sure what else to suggest. It should be able to import an Excel column
that contains numbers and text into a Text type column.