Recent content by LeeIsAlive

Hi All, Many thanks for your replies. It solved my problem in the end! If I use excel (vs txt) and I specifically define the columns as text (vs general), access is now importing correctly my data. A life saver! :-) I still find it strange that MS Access would look at the source format...

Thx, but I don't get the option to define the data type when importing into an existing table. That option is only available when you import into a new table. I've read about people having similar issues (leading zero's dissapearing after the import). One of them mentioned to add a dummy row...

Ok, I found the import specification (when saving the settings of an import, save as...). But this doesn't help me. When I searched google for import specification on Access I saw pictures where you have the following: Field information: Field Name: Data Type...

Hi Mr. B Thanks, that sounds promissing. Though I can't find "Import Specifications" back in Access.. Can you direct me to it? Thanks, Lee

Hi All, Can someone help me with the below problem? I'm having a number of tables in Access which I want to populate with data from excel/txt. In my import files I have some columns which contain alphanumeric data, like 0001 or XYZ0. I've defined these columns as text in the definition of...