By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,434 Members | 2,963 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,434 IT Pros & Developers. It's quick & easy.

how to split microsoft access table into different tables,

P: 1
hello guys,

i need your help on how to split a microsoft access table into 2. Actually i have more than 1.4m rows and i need to export these data into excel. So i need to write a query which will split these rows into 2 different table.

After that i will use these data into excel for some comparison.

your help will be much appreciated.
Feb 11 '19 #1
Share this Question
Share on Google+
1 Reply


Nauticalgent
P: 92
Look into Make Table queries. In the query you include only the fields you need. However, if your ultimate goal is to export the query to excel, your best bet is to make a select query, and then simply export the query to excel.

This will preserve the integrity of your data and reduce the possibility of bloat.
Feb 12 '19 #2

Post your reply

Sign in to post your reply or Sign up for a free account.