asked on

Import very large txt text file 101MB in MS Access

I have a very large file in text format (txt) 101 MB that I can open in Notepad after 5 min

I need to import it in MS Access.
Uusing the import wizard function after 25/30 min the system says "the first row is too large". However I can not cut the first row in notepad
I tried twice, error message was the same

When trying to import this file in MS Excel using the import function, the system says "No memory" after 5/15 min

I tried to cut the notepad in half.. very long and tedious and the part I could open was not a proper representation of this section in notepad

Any advice to handle this case?

Thanks

ASKER CERTIFIED SOLUTION

SimonLarsen

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

pollacsekv

ASKER

Thanks Simon

can not download right now the editpadpro b/c of admin access needed

Will try last option .. what is the import specification? where do I input the information for the import specification?
I have not seen this option in import wizard function

Txs

SOLUTION

Bob Lamberson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SimonLarsen

When you do an import click on the advanced button. It lets you save or laod an import specification.

SimonLarsen

Something just occurred to me, editpad pro has a demo version and is just an executable from memory. So you should be able to run it as is, no admin needed.

frukio

any chance that the file has mac / unix line breaks?
this would cause Windows applications to see the entire file as a single line.
if so you would need to convert the line breaks somehow (BBEdit, vim, probably any number of little shareware tools just for converting linebreaks)

pollacsekv

ASKER

Hi,

to reply to Simon and Frukio,
1) copying editpadpro that a colleague download it, my machine automatically erase it from C\:

2) What are the mac/unix breaks?

Thanks

SOLUTION

frukio

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SimonLarsen

And while you're in notepad grab a couple of lines for a new file to check for anything else.

It is going to the linebreaks though.

frukio

Oh, Simon is right - down arrow in Notepad doesn't have anything to do with line breaks, it just moves the cursor down, wherever that happens to be.

You could try turning off "Word Wrap" in the Format menu.

Steve Bink

Do not accept this as a solution.

All experts had valid methods to try, hence the recommendation. I use UltraEdit myself, and IT ROCKS! Handles Unix/Mac formatting as well as DOS, and even has a hex editor for those hard to reach places...