Recent content by 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...

correct. It seems like a lot of spreadsheets but they are going to be grouped and distributed across the company network, so I can't get away from needing all 34,000

correct (You are really struggling to get over this 34,000 thing aren't you!!)

sorry bit of a misunderstanding. I need the tables exported as seperate excel files not into the same spreadsheet. I somehow need to specify a variable in the file path section of the transfer text method

aarrgghh!!!! it's fallen down again. The microsoft jet database engine cannot open 'C:\Projects\' It is already opened exclusively by another user, or you need permission to view its data. and it debugs to DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, tdf.Name...

its fallen over with the following error Runtime error '13' Type mismatch and it is debugging at For Each tdf In db.TableDefs :confused: :confused:

Thanks I'll give that a go now and keep you posted

Export EVERY table from a database Is it possible to export every table from a database?

The master table contains approx 750k customers. Each customer is serviced by one of our 34k collectors. The code runs through the master table and produces a table for each individual collector with their clients. These files are then being imported into GIS software to go to the Concession...

Here's the problem. I have a piece of code that runs through a master table and based on specific criteria writes results out to tables. (i.e. Glasgow - 123A321, Glasgow - 123A112, Glasgow - 321B159, Perth - 987A65, etc). In total there are 34,000 tables. I need to export these tables from...

Oh dear. I'm afraid that is were we have a difference of opinion. I am hoping that it goes to extra time and the players are knackered, a couple of players are ruled out with injury for the rest of the season and we go on to cement fourth spot!!!

Oops. My mistake, you did mention that before you are right. I've run it again and it falls down with the following error. Run time error 3265 Item not found in this collection and it debugs to newtbl("POOLSCARD_NO") = master("POOLSCARD_NO") oh no hold on I've spotted the mistake. The...

I get the following error Run-time error 3010 Table Edinburgh - 146J002 already exists and when I debug it highlights dbscreatetabledef.TableDefs.Append tdfNew

For Littlewoods Pools on Walton Hall Avenue. Data Analyst / Database Marketng Exec / Database Designer / Cleaner / Car Park Attendant (You get the picture)

The field that the table needs to be split on is the NAME field which contains the collector reference. Query1 now references the Edinburgh table. BTW didn't notice that your location is Liverpool. Whereabouts are you?