copy from dbf and paste to xls

G

guy

Currently i can open file1.dbf file with excel, then MANUALLY copy and paste
the content of file1 onto "worksheet1" in file2.xls.
After that, i run a macro that select particular rows in "worksheet1" and
paste them to a blank "worksheet2" in the same workbook.
Now i want to automate the manual copy and paste process. What can i do? Can
i use SQL to select rows from the dbf and paste them on "worksheet2"?

Thanks!!
 
J

jaydywan

Currently i can open file1.dbf file with excel, then MANUALLY copy and paste
the content of file1 onto "worksheet1" in file2.xls.
After that, i run a macro that select particular rows in "worksheet1" and
paste them to a blank "worksheet2" in the same workbook.
Now i want to automate the manual copy and paste process. What can i do? Can
i use SQL to select rows from the dbf and paste them on "worksheet2"?

Thanks!!
Click to expand...

Have you tried creating a "New Database Query" in excel, under "Data",
"Import External Data"?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste options button disappears 0
How to paste this down? 3
Copy addition formula of non-consecutive horizontal cells 2
Create a dynamic master file 1
Folder structure in teams channel. 0
Paste Link and Link Text From Browser to Word 0
Copy and Paste Word 2010 0
adding vlookup into Macro and table_array is different every week. 1

Top