×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Open a CSV.file and save it in XLS Format

Open a CSV.file and save it in XLS Format

Open a CSV.file and save it in XLS Format

(OP)
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!  

RE: Open a CSV.file and save it in XLS Format

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

----signature below----
Majority rule don't work in mental institutions

My Crummy Web Page

RE: Open a CSV.file and save it in XLS Format

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

RE: Open a CSV.file and save it in XLS Format

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

Thanks,

Alex

----signature below----
Majority rule don't work in mental institutions

My Crummy Web Page

RE: Open a CSV.file and save it in XLS Format

(OP)
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                                                

RE: Open a CSV.file and save it in XLS Format

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close