copy from dbf and paste to xls

  • Thread starter Thread starter guy
  • Start date Start date
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!!
 
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"?
 
Back
Top