424,303 Members | 1,366 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,303 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.
1 Week Ago #1
Share this Question
Share on Google+
1 Reply

P: 81
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.
1 Week Ago #2

Post your reply

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