I know MySQL but I don't know Access. I have nearly 1 million rows and I want only the rows between 300 000 and 500 000. I mean as seperate file. I don't need the ones before 300 000 and the ones after 500 000. How I'll do it?
The Access is 2013.
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.
Sign up to join this communityI know MySQL but I don't know Access. I have nearly 1 million rows and I want only the rows between 300 000 and 500 000. I mean as seperate file. I don't need the ones before 300 000 and the ones after 500 000. How I'll do it?
The Access is 2013.
To export the rows to CSV, Excel, etc.
To create a table in another Access database
If you can base the range on an ID, the query is simple enough:
DELETE
FROM Table1
WHERE Table1.ID<300000 Or Table1.ID>500000