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!

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

Exporting

Status
Not open for further replies.
SpiderBear6

SpiderBear6

Programmer
Sep 17, 2003
422
AU
I have a table with over 100,000 records in it and I need to export it to a comma-delimited text file. I have tried using the Export menu item when you right click the table name but I get an "Invalid Argument" error when I click on the Finish button. I suspect that it's because of the number of records. How else can I get this table into a comma-delimited text file?

Please help me... [sadeyes]

 
Sort by date Sort by votes
I think I found a way. If I import the tables into a SQL Server database and then open the sql server database from access 2000, it lets me export the larger tables.

Excellent.. I didn't want to have to write an app just to export some tables as comma-delimited files.

[shadeshappy]

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

techkenny1
  • Locked
  • Question
Exporting a table to CSV format 1
Replies
1
Views
58
dhookom
dhookom
subs1678
  • Locked
  • Question
exporting access into excel
Replies
2
Views
37
pbrodsky
pbrodsky
aspiringprog
  • Locked
  • Question
Exporting from access database 1
Replies
5
Views
47
aspiringprog
aspiringprog
Robyne
  • Locked
  • Question
Exporting Data
Replies
1
Views
37
Remou
Remou
Jokkis
  • Locked
  • Question
Problem when exporting
Replies
3
Views
34
Golom
Golom

Part and Inventory Search

Sponsor

Back
Top