DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 5 of 5

Thread: importing a text file into excel component in vb6

  1. #1
    Join Date
    Oct 2005
    Posts
    133

    Question importing a text file into excel component in vb6

    hiya all

    merry christmas once again to everyone

    i understand the principals of connecting to an excel spreadsheet by using the properties of an Ado control , but how would i go about importing a text file into an excel component control on my vb6 form (using office web components control)

    please any help would and always is greatly appreciated

    Rob
    yet another problem i know can be solved

  2. #2
    Join Date
    Dec 2003
    Posts
    2,750
    Which Office Web Components control(s) are you using?

    Can we assume the text file you are referring to is column delimited (by a comma for example)?
    Paul
    ~~~~
    Microsoft MVP (Visual Basic)

  3. #3
    Join Date
    Oct 2005
    Posts
    133
    hi there,

    hope you all had a great christmas...

    i am using office wep components 11.0

    and unfortunately not the text files i want to import intoexcel will be delimeted after import

    thanks for your help so far

    Rob

  4. #4
    Join Date
    Dec 2003
    Posts
    2,750
    Yes, but which of the web components are you using? Spreadsheet? DataSourceControl?

    Do the text files have any kind of format? Can you provide an example of how you want to display it in a web component?
    Paul
    ~~~~
    Microsoft MVP (Visual Basic)

  5. #5
    Join Date
    Jul 2004
    Location
    St. Louis, Mo
    Posts
    111
    If you have solved this problem would you post the solution.

    I have TEXT file that originally was an Excel CVS file with 7 columns and an unknown number of rows, less than 600, but now is a TEXT file, unfortunately.

    I want to move it to Excel.

    Thanks

    Winnie-the-Pough (sic)
    "good food Like good software takes time to prepare"

Similar Threads

  1. Replies: 8
    Last Post: 11-27-2008, 03:13 AM
  2. problem in opening XML with EXCEL via VB6
    By eranfox in forum VB Classic
    Replies: 5
    Last Post: 08-09-2007, 07:18 AM
  3. Replies: 1
    Last Post: 03-23-2005, 12:18 AM
  4. Replies: 2
    Last Post: 05-31-2000, 10:11 AM
  5. Replies: 0
    Last Post: 04-17-2000, 01:33 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center