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

Copy files to dbf files 2
copy latest price from sheet1 to sheet2 using VBA 4
Select Cell in first blank column of a row 2
Macro Help 3
Copy, paste first empty row 1
Help writing macro for a lookup table 1
How to copy and paste multiple files 2
Copy a row down a column for the same number of rows of data in another workshee 6

Top