copy Table

[rameshmeena]

Sir,

I am a beginner, I need to export data from my table to another database

I am using the following command

sFile = CurrentProject.Path & "" & Format(Date, "dd-mm-yyyy") & ".accdb"



DoCmd.CopyObject sFile, "employees slected data", acTable, " employees data"

I dont want to copy all datas from Employees data. I need only selected data, means, those employees whose basic more than USD 250

how can i create it on the above Docmd

Pleas help

[andy49]

Write a query which gets the data you want.

Then change actable to acquery

And the name "employees data" to your queryname.


Sent from my iPhone using Tapatalk

[rameshmeena]

thank you for your immediate response.

I tried this option,
The output file which i am generating will be stored as an access file name " dd-mm-yyyy : ( 26-03-2017.accdb) contains the table : Employee selected data "
dont have any records.

I need to output file table contain the selected data for the employees basic more than USD 250
Purpose of this table is to import to another data base.

[andy49]

One option is to change your select query into a maketable query. Then export that data using the code you have


Sent from my iPhone using Tapatalk

[rameshmeena]

Dear can you please tell me what is marketable query,m i didnt understand it clearly

[andy49]

Certainly.

When you open the query I mentioned in #2 in design view, you'll see the word "make-table" at the top. Click on this and then run.





Sent from my iPhone using Tapatalk