Importing table

[kevin]

Hi

i am creating a new table importing from excel. I am
losing information because one of the fields Access is
assuming it is a number field so deletes any text data.
How can tell access that it is a text field. there doesnt
appear to be an option in the wizard

I am using Access 97
thanks

 

[John Vinson]

Hi

i am creating a new table importing from excel. I am
losing information because one of the fields Access is
assuming it is a number field so deletes any text data.
How can tell access that it is a text field. there doesnt
appear to be an option in the wizard

Don't import: Access (as you see) makes guesses, often incorrect,
about the datatype. Instead create your table with the desired
datatypes, and use File... Get External Data... Link to link to Excel;
then run an Append query to move the data into your Access table.

Even this might not always work; you may want to put a "dummy" row at
the top of the spreadsheet with "THIS IS TEXT" in the column that
contains mixed text and numbers.