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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export selected rows

Status
Not open for further replies.
balajishankar

balajishankar

Programmer
Sep 16, 2012
1
US
Hello,

I am a beginner in VBA. I am trying to export a 5000 record access table to a csv file. I need to export 1000 records each of the same table to 5 csv files. Can someone help me with this? How do I select just 1000 rows in the table and export one ata time?

Thanks for you help.

Bala
 
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Question
Delete dynamic table rows without removing password protection
Replies
7
Views
404
remeng
remeng
linuxguyEastCoast
  • Locked
  • Question
export text from non-public docx, pptx, pdf
Replies
0
Views
414
linuxguyEastCoast
linuxguyEastCoast
kapok1
  • Locked
  • Question
how to use vba to forbid "Worksheet Menu Bar" being selected
Replies
6
Views
371
kapok1
kapok1
davefish
  • Locked
  • Question
Looping through a word doc to delete rows
Replies
7
Views
298
macropod
macropod
MattGreer
  • Locked
  • Question
Excel - Copy Filtered Rows from a table to a new blank worksheet
Replies
7
Views
296
combo
combo

Part and Inventory Search

Sponsor

Back
Top