import format

[slimjen]

All, I am importing excel spreadsheet into an existing table. I have one column that is an alphanumeric field in the table therefore i need the field in excel to import as text. The field consist of a tracking number. when it's ups(1z444xxxx) imports fine but when the tracking number is all numbers it fails to import successfully. I have been stressing over this many times and I have to resolve this. I tried inserting a row and putting text in the field but this results in unnessary data in the table. Please help
Thanks

[JoeM]

Are you certain that it is that field that is causing the import to fail? If it is a text field, it should have no many accepting an all numeric entry.

I was helping some one out the other days with an Excel file import (they can be problematic). Check out my comments/suggestions here: https://www.accessforums.net/import-...tml#post129442

[slimjen]

Thank Joe. I've been fighting with this a long time now. I am importing into an existing Access Table and do have the field formated as text but even then Access ignores this. Reading you post gave me the idea of having the user add a letter to the first 10 fields of numbers before importing and voila! Microsoft should be ashamed of thereselves because these two programs with office work so often and close together. I too used to change the excel spreadsheet to text and have an import specification but you just can't do this with the excel file and you just should be able to! Thanks so much again.