.CSV - Text file

[mereclain]

Morning all -

I'm trying to import a text file in csv format into Access but I'm getting the following error message: "Record is too large."

Then, using VBA in Access I tried to open the file using the opentext method, and I'm getting the following message: 'Run-time error '': Method opentext of object workbooks failed"'

What am I doing wrong?

 

[FoFa]

It sounds like the text file is not properly formatted with CR/LF at each line end.
Have you tried opening it in Notepad (or some similar text editor)?
Some times you can open them in a text editor, than resave them if they look OK (different name please) and then they work OK.

 

[mereclain]

Okay, I tried what you said. Save in notepad and then try to import. I still received the same error message when I imported:"Record is too large"

Thanks. I'll try to something else unless someone else can help resolve this.

Again, thanks for the help.

 

[FoFa]

The other that comes to mind is if you are using an Import Specification, you may have it defined differently than the record layout. Also can you open the CSV in Excel and have look right?
Also one other thing, are there any characters in your data throwing the format off (like double quotes in a text field) that would cause the system to think you have a string larger than 256 or something like that?