Open a CSV.file and save it in XLS Format

[alorenzini]

How can I open a CSV file and then save it as an Excel file within an ActiveX Script. It is going into a DTS package.
I have a file that is imported from a vendor in a .CS (C Sharp?)format. The only application that I found that it will let me open it is EXCEL. So my thinking is open the file in an Excel object then save it as a XLS file and then I can use transformation to move it into a SQL table.

Thanks,
Art
Database Analyst
Tastefully Simple, Inc.

alorenzini@tastefullysimple.com
" Some days, it's not even worth chewing through the restraints!

 

[AlexCuse]

What does the file look like if you open it in notepad?

If it's a CSV file you are better of working with it as such.

Hope this helps,

Alex

[small]----signature below----[/small]
Majority rule don't work in mental institutions

My Crummy Web Page

 

[alorenzini]

It comes up with some odd looking stuff (See attachment).It is evidently not a .CSV file but it will open in Excel.

 

[AlexCuse]

I can't seem to open the attachment. Can you post the first few lines of the file? (replace any sensitive information).

Thanks,

Alex

[small]----signature below----[/small]
Majority rule don't work in mental institutions

My Crummy Web Page

 

[alorenzini]

This is basically the header row and little more.


. Â^
TRACK_NO C  PKGID C  STATUS C  CARRIER C
ACT_WGT N
 SHP_WGT N ..................00 1 1 Y
1 N 0.00 0.00 0.00 0.00 0 0.000 0.00 0
0 0 194 1U112008020108:09:294505977096 105 0
0.0000PERSONAL
UPS Ground 320.760.3807

 

[travisbrown]

Looks like a tab-delimited file, which is similar to a csv, only using tabs instead of commas for delimiters. You can treat it similarly.