[MS_AccessPros] Importing text file into Access 2007 problems

 

Hello everyone,

I'm running into a major problem with Access 2007 when importing a text file into the software (.txt format). I have never had a problem with this until now. These are the steps that I have done and I do apologize if this has already been discussed.

1: Click external data
2: Click text file
3: Browsed to the file location on my computer
4: I selected "Import the source data into a new table in the current database."

5: I clicked "OK" and selected 'fixed width format' since thats what access believes it in.

6: I clicked next on the next options
7: Access pops up with a message saying "The size of a field is too long"

Any help would be greatly appreciated as i'm trying to complete a database for clients.

Mark

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 5
• New Files 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___