coding text to column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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
 
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.
 
Back
Top