Importing Problem

  • Thread starter Thread starter OEJ29
  • Start date Start date
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..
 
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

Similar Threads

Need help Plz - Error message Importing a txt file via Wizard 1
How do I import a signed field into access data base? 1
How to import singular charectors of text? 0
Importing Excel Data Into MS Access Memo Field 2
Import Text File with Import Spec 3
Handling é in Imports/Exports 2
Importing error in Access 2003 3
Import Fixed Width (.dat) file 7

Back
Top