Importing data

[juliejg1]

I have an access table that I have been using for quite some time. I import
the same formatted excel file each month. I have added a new field to the
end of the table and excel file. It is a simple text field and does not
contain any blanks or numbers, etc.... I have never had a problem importing
the file until I added this field. Now it will not allow me to import the
file. Do you have any suggestions?

 

[strive4peace]

Hi Julie,

does this additional column in Excel sometimes contain numeric data?

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*

 

[juliejg1]

no, always text and it is actually only one letter

 

[strive4peace]

Hi Julie,

what is the method you are using to import the data?

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*

 

[juliejg1]

File----Get External Data

Hi Julie,

what is the method you are using to import the data?

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*

 

[Dale Fye]

Are you using an import specification? If so, you will need to account for
that new field.