I have an Access file with 2 Columns (ID and Code) and 4,800,000 rows. I need to convert into 10 csv files with approximately 500,000 records each. Any suggestions would be greatly appreciated.
Thank you!
I have an Access file with 2 Columns (ID and Code) and 4,800,000 rows. I need to convert into 10 csv files with approximately 500,000 records each. Any suggestions would be greatly appreciated.
Thank you!
Create a query. Add a field that creates a number 1up from the previous record if this is not already in your table. Set the criteria for this Unique field Between 1 and 500,000, then run it again with the criteria Between 500,001 AND 1,000,000, continue until all files have been transferred.
I have this question too. So there's no other way to do this automatically? We have to manually go in and create a record ID and export 1-50,000 and 50,000-100,000 and on separately? How do we create that record ID?
Thanks!