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 derfloh 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
Joined
Sep 16, 2012
Messages
1
Location
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 Question
Delete dynamic table rows without removing password protection
Replies
7
Views
873
remeng
remeng
linuxguyEastCoast
  • Locked
  • Question Question
export text from non-public docx, pptx, pdf
Replies
0
Views
604
linuxguyEastCoast
linuxguyEastCoast
kapok1
  • Locked
  • Question Question
how to use vba to forbid "Worksheet Menu Bar" being selected
Replies
6
Views
770
kapok1
kapok1
davefish
  • Locked
  • Question Question
Looping through a word doc to delete rows
Replies
7
Views
765
macropod
macropod
MattGreer
  • Locked
  • Question Question
Excel - Copy Filtered Rows from a table to a new blank worksheet
Replies
7
Views
798
combo
combo

Part and Inventory Search

Sponsor

Back
Top