TrasferText Method (with Variables)

[dopedealer]

Well,
Its just strange to accept 34,000 tables in an access database as access permits 2gb as a cut off for the storage. If your wanting to see all that data in excel sheets, what was the whole point of the database in the first place?

 

[goldenvision]

Access was always just a means to an end with this project.

My brief was to obtain the 750k customers from the database. Output a spreadsheet for each collector with their related customers. I was originally looking at copy/paste function in excel but as excel maxes out at 65k this would have been very messy.

I figured that access was the best bet to get it in, sorted, output and exported.

The files have got to be exported as spreadsheets as the end users only have the use of excel.

Hope that clears a few things up.

Back to the original question of how to export all of the tables into excel?