Import 8gb Text File

[Brianfree]

Hi, i have an 8gb text ile which i am trying to import into a linked table (odbc to mysql), Anyone got any ideas on how to do this? Im using Acess 2007

Many thanks,

Brian

 

[Brianfree]

Forgot to mention that i have also got a saved import method which i have tested on a smaller freaction of the database, which works ok.

 

[TonyJollans]

I can't actually help - I've never tried to use Access with a MySql back end, but what's the problem? Your test worked, it's time to go for the real thing.

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

I'm working (slowly) on my own website

 

[Brianfree]

HI, the test was just a snapshot of the data to see if all the values went into the right field. The file is too big for access to handle so im not sure if there is a macro or another way to import it....

Cheers..

 

[SkipVought]

Why would you IMPORT the data into Access, when it is in your SQL Server database?

Just LINK to it and Query as needed.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

oops, maybe I made the wrong assumption.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[fumei]

I






am





just







shocked

Gerry

 

[SkipVought]

heeeeyyyyy Gerry!

You can't do that! Your time ran out over the weekend, cuz we're into a new month! [gray]_{playin'around in your tights!}[/gray]

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[kjv1611]

If you're wanting to go from a text file to MySQL, then you don't need Access in that loop, I'd say it just muddies the waters.

See if you can find help here:

http://www.webmasterworld.com/databases_sql_mysql/3371871.htm

Specifically, it says for Windows uers, the second link, which goes to a download for a custom-built app for importing large text files into MySQL:

http://dev.mysql.com/doc/refman/4.1/en/mysqlimport.html

So with all that in mind, why are you asking this in a MS Office forum, and do you have some specific reason for wanting to use Access between your text file and MySQL?

--

"If to err is human, then I must be some kind of human!" -Me