Importing from Oracle extract....

[JasonS]

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

 

[Michael Hopwood]

Why not use a linked table?

1. Set up an ODBC connection to the Oracle db
2. File | Get External Data... | Link Tables
3. Follow the steps to link the table

You now have a table within Access of live data which you can run queries
against etc.

 

[Steve Schapel]

Jason,

Answered in macros newsgroup.

A hint for the future... if you really think it is important for your
post to appear in more than one newsgroup (in practice, it is seldom
necessary), please cross-post (i.e. address the same post simultaneously
to both groups), rather than multi-post (i.e. send a separate copy of
the message to each group). Thanks.