Re: import large text file

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks, Cor. That's very interesting; I didn't know that could be done. I
have checked out your website in the past, and found it very helpful. I
should browse more...

Have a great day!
Robin
---------------------------------------------
"Cor Ligthert [MVP]" <notmyfirstname@xxxxxxxxx> wrote in message
news:%23tMyMCnYHHA.4308@xxxxxxxxxxxxxxxxxxxxxxx
Robins,

The difficult is that you only can use it to store with a program. As
soon as you try to use it in by instance Office Access than it is
impossible.

However you can try it just as you do a blob. If you want a sample. on
the website from Ken and me is more than enough about that.

If there is a problem than tell it (you are amongst those who I will help
via mail as well).

Cor

"RobinS" <RobinS@xxxxxxxxxxxxxxx> schreef in bericht
news:oI2dnQXyrYgPaG3YnZ2dnUVZ_t2tnZ2d@xxxxxxxxxxxxxx
I don't know what my answer would be then. I'd have to try it out. So
you're telling me you can store it as a zipped file, and unzip it to run
a query against it?

Robin S.
---------------------------------------
"Cor Ligthert [MVP]" <notmyfirstname@xxxxxxxxx> wrote in message
news:%23ohiT1QYHHA.4440@xxxxxxxxxxxxxxxxxxxxxxx
Just text

what would you than answer?
what would be your answer then?

"Cor Ligthert [MVP]" <notmyfirstname@xxxxxxxxx> schreef in bericht
news:e0OYUePYHHA.4440@xxxxxxxxxxxxxxxxxxxxxxx
Robin,

Why not, if I would ask you how can I in the easiest way make this
routine bellow quicker, what would you than answer.

dim a as float
for I as integer = 0 to 100000000000000
a = a + 1
end for

It is in my opinion almost exactly my answer.

Update(Zip(MyFile))

MyFile = Unzip(Execute.Scalar(Select myfilecolumn from Server where
bla ) )

Cor

"RobinS" <RobinS@xxxxxxxxxxxxxxx> schreef in bericht
news:d7udnX24-_WMnXLYnZ2dnUVZ_t-mnZ2d@xxxxxxxxxxxxxx
Thank you, that's exactly what I meant. Importing a zip file into a
column in a table isn't what the guy was going after.

Robin S.
------------------------------------------

"mojeza" <najyer@xxxxxxxxxxx> wrote in message
news:1173272208.109134.86530@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Cor,

If you read the original post again you will notice that question
was
how to IMPORT data from a text file into Access database not how to
SAVE text file in a database. This is why RobinS try to say that
zipping a text file wont help this process.













.

Relevant Pages

  • Re: import large text file
    ... dim a as float ... MyFile = Unzip(Execute.Scalar(Select myfilecolumn from Server where bla ... Robin S. ... how to IMPORT data from a text file into Access database not how to ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: import large text file
    ... MyFile = Unzip(Execute.Scalar(Select myfilecolumn from Server where bla ... Robin S. ... If you read the original post again you will notice that question was ... how to IMPORT data from a text file into Access database not how to ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: import large text file
    ... you're telling me you can store it as a zipped file, and unzip it to run a ... Robin S. ... MyFile = Unzip(Execute.Scalar(Select myfilecolumn from Server where ... how to IMPORT data from a text file into Access database not how to ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Using "OleDbParameter" with a DateTime type
    ... JavaScript error inside one of the controls, ... datetime field in Access. ... the Time portion) of the value gets written to the Access database column. ... We have at the moment a minor problem on our website. ...
    (microsoft.public.dotnet.framework.adonet)
  • 2 questions -frontpage 2003 and access - multiuser and report generation
    ... I am not sure what to set on my website to allow multiuser access to my ... Access database. ... reports: what is the best way to generate them? ... without prompting the user to change to landscape.. ...
    (microsoft.public.frontpage.client)