Merging a CSV and XLS file automatically

[Maxwell2006]

Hi,

I have a csv fles on the network derive that is being updated every night.

I need to automatically put the CSV data into the first worksheet of another
XLS file and make it available for users.

I can have a scheduled task runs and merge the CSV into the XLS file.

What would be the easiest/automated way to do that?

Thank you,
Max

 

[Guest]

1. Open your xls
2. Write a macro
Macro does this:
1. Reads the CSV into an ADODB.Recorsdset object (works best if the CSV has
column headers).
2. Insert a new worksheet
3. Use CopyFromReordset to send the ADODB.REcordset to the new sheet.

.... save the workbook

 

[Maxwell2006]

A batch job (windows scheduled task) supposed to do that. Can your solution
be called through a scheduled task?



Thanks for help,

Max

 

[Peter Huang [MSFT]]

Hi

It seems that you have posted the question in other newsgroup.
Someone has replied to you.

Also I think you may try to write a VB6 application which will do the same
job and the code will be similar. That is called automation.
295646 How To Transfer Data from ADO Data Source to Excel with ADO
http://support.microsoft.com/default.aspx?scid=kb;EN-US;295646


Best regards,

Peter Huang

Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.