Recent content by zaaimanm

Sorry, I am using access and excel 2010.

Thanks for the reply, Once the records are exported they will be given to different data processors. I am unclear as to what they will be doing with the data, at the moment it’s just a headache exporting over 3 million records. I have a file in the C Drive called Access In Port, I have the...

IN total I have 4 million records I need to export, what do you think will work the best and what code do I need. :)

HI, I need to use the code ypu hasve fpr To copy one Access table to multiple worksheets in Excel (10,000 rows takes about 1 minute to copy): When using this i get the following error. The object doesn't contaim the Automation object '<<recLimit>>.'. Please help

Thanks for the response. The reason I need it separately is because of the amount of records, The database is currently at 3 million records but will be growing to about 6 million in the next month or so. I am really open to options, if it will keep populating into a new sheet in the...

Hi, New to VB.:confused: but Learning fast. I have a database with 2mil+ records in it, about 8 columns. I need to create a Module that I can link to a button that will export the records into excel, when the max records for the spreadsheet is reached it needs to overflow into a new...