Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Import all rows from text except last three lines

Status
Not open for further replies.
Jun 11, 2003
3
US
I am trying to import a csv file into Access 2000 that is spooled from Oracle that has the following format:

A.FIELD1||','||B.FIELD2||','||B.FIELD3
--------------------------------------
Value1,Value2,Value3
Value4,Value5,Value6

2 rows selected.


I actually have 2 questions:
1) Is it possible to replace these headings with something more useful?
2) Can I import everything except the last row (containing "2 rows selected.")?

Thanks in advance!

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top