Importing from Oracle extract...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JasonS - 05 Jun 2004 19:12 GMT

Hello!
Please, help me with this issue: I got a file which is an extract from
Oracle database, and I want this file to be programmatically imported into
MS Access table.
This is an example of what kind of data this file contains:
243,177,699990000,"222222222222222222","333333335555555","
",0,"AddressesOfsomeone",Yes
The last line contains nothing but a graphical square :-/
The first line does not contain headers for fields.

The file contains about 500 000 of such lines, so it's impossible to import
this file into Excel. When I'm importing it into Access using
DoCmd.TransferText method, I get an error message telling that there is no
F1 field in corresponding table in Access database.
The problem dissapears when I'm manually removing "-signs from that file.
But, is it possible to do it programmatically using VBA?
How can I open for editing an external file in txt format in VBA and remove
all " and that fu**ing square at the end of the file and finally save it to
the hard disk?

Thank you 4 helping me :)
Greetings from a stupid polish guy

Reply to this Message

Steve Schapel - 05 Jun 2004 19:40 GMT

Jason,

Is this a one-off import, or is this something you need to do regulatly?
If it's just a one-time need, I suggest go to the File|Get External
Data|Import menu, and get the data into an Access table through the
Import Wizard. That way you can designate the type of file you are
importing from, field data types, etc, and I would expect you should
have no problem getting this to work. If it is a process that you will
need to repeat, wehn you get to the last screen of the Import Wizard,
click the 'Advanced' button, and save your setup as a Specification.
Then, enter this in the Specification Name argument of your TransferText
macro.

Signature

Steve Schapel, Microsoft Access MVP

> Hello!
> Please, help me with this issue: I got a file which is an extract from
[quoted text clipped - 18 lines]
> Thank you 4 helping me :)
> Greetings from a stupid polish guy

Reply to this Message