copy from dbf and paste to xls

's Computer Specifications

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!!

's Computer Specifications

On Jul 12, 2:48 pm, "guy" <g...@email.com> wrote:
> 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!!

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I get copy/paste to copy/paste text and not the whole page	=?Utf-8?B?Q2Fyb2wgSi4=?=	Microsoft Word Document Management	1	6th May 2005 09:03 PM
Copy and Paste macro needs to paste to a changing cell reference	=?Utf-8?B?bG91bG91?=	Microsoft Excel Programming	0	24th Feb 2005 10:29 AM
Copy & Paste Object without using the Excel Copy Paste functions	=?Utf-8?B?R2Fueg==?=	Microsoft Excel New Users	0	10th Mar 2004 07:06 AM
Copy & Paste Object without using the Excel Copy Paste functions	=?Utf-8?B?R2Fueg==?=	Microsoft Excel Misc	0	10th Mar 2004 07:06 AM
Re: Copy/Paste in Excel prints highlighted cells and does not paste	Dave Peterson	Microsoft Excel Misc	0	30th Jul 2003 11:08 PM