Import error list

[rbrule]

Hello,

I have been trying to import an excel sheet into access. One field continues to be a problem. Half the data in the field winds up on the import error list, because of a type conversion problem. Half the data are clear three digit numbers and the other half are alpha numeric. The import will not let me change the data type.
I have tried changing the field to a text field in excel prior to import, but that didn't work, the field still did not convert to text in Access. I tried saving the excel sheet as a text file, and although it cleared up one problem, it created one with a date field, which I couldn't correct.
Is there another way to solve the problems with the import error list?

 

[Mile-O]

Is it a text field in Access? If not, it should be.

 

[rbrule]

It would be a text field in Access, if I could import it, however when I import the excel sheet the data type is grayed out and it shows as Double.

How would I make the change prior to the import so that it imports as a text field?

 

[texasalynn]

Some workarounds:

1. I have found a way to fool Access is to open the text in Excel and move to the first line the data with the correct field type. Then when you import it works just fine.

2. Import the data into the table. Delete the records. Change the field type to text. Re-import the data.

HTH
texasalynn

 

[rbrule]

Thank you, that sounds like a very logical approach.

rbrule