Importing table

  • Thread starter Thread starter kevin
  • Start date Start date
K

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
 
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
Click to expand...

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.
 
Hi Kevin,

What I generally do when importing data, whose field types I am not sure
about, is to change ALL the field in the Import Wizard to text.

Once the data has been imported successfully, I then go into the
newly-created table and change the data fields to the correct data type.

Alan
 
Back
Top