Export from one Access table to multiple new Excel workbooks based on data

F

fpcsql

Joined
Aug 13, 2006
Messages
2
Reaction score
0
I have one table containing +-155000 records and I need to split it into +- 4600 different Excel workbooks based on data in one column. (for each different value I require a new workbook)

I assume I should write a procedure in VBA, only I have very limited experience in VBA and would really appreciate clear instructions.

Much appreciated. :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting Data to One Excel Workbook to Several Worksheets 2
Exporting pivot tables to excel 1
How to export table from outlook into ms access table? 0
Excel, assign cells in multiple worksheets from one sheet 1
Export From Access to Excel To Individual Worksheets 2
importing multiple worksheets from excel to access 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Import Excel 2010 table into Access 2010 - not listed as range 1

Back
Top