Importing Problem

O

OEJ29

I have a fixed width text file (.txt) that I am able to open with Excel, but
when I try a straight import into Access from the .txt file, I get the
following error:

One or more rows of data in your file contain too many characters to import.
The maximum characters per row is 65000.

Why am I able to import the same file into Excel and can I get Access to do
this without having to create the additional step of converting from .txt to
..xls?

Thanks in advance..
 
M

Mark A. Sam

During the import process, you have the ability to assign the field type of
the imported fields. They changing the problem field to a memo field type.

God Bless,

Mark A. Sam
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top