SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 6 of 6
  1. #1
    Senior Member
    Join Date
    Jan 2003
    Location
    Portland, ME USA
    Posts
    603
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Comma Delimited files,

    Has anyone been able to use the silk DB functions to read froma comma delimited file?

    I do have a schema file, it that helps.

    Thanks in advance...
    N+ CNA

  2. #2
    Super Member
    Join Date
    Jul 2003
    Location
    Boulder, CO
    Posts
    1,276
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Comma Delimited files,

    I guess you want queries such as SELECT to work on the data?

    Excel should be smart enough to read the file in if you specify the right params. Maybe you could do this and then use the SilkTest Excel interface?
    Chris R Mead

    The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

  3. #3
    Junior Member
    Join Date
    May 2005
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Comma Delimited files,

    Please do a search in qaforums. This question has been answered previously...
    Check this
    http://www.qaforums.com/cgi-bin/foru...c;f=1;t=007611

  4. #4
    Senior Member
    Join Date
    Jan 2003
    Location
    Portland, ME USA
    Posts
    603
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Comma Delimited files,

    I have used the DB function with excel extensivly, but i have never used it on a Comma Delmited file. How do you connect to the file with Excel?

    Thanks
    N+ CNA

  5. #5
    Super Member
    Join Date
    Jul 2003
    Location
    Boulder, CO
    Posts
    1,276
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Comma Delimited files,

    Unfortunately, I haven't used Excel 'programatically'. I've converted comma delimited files to spreadsheets by doing something like File > Open > (comma delimited text file name). Excel will then give you a dialog with options regarding how to parse the text file. Comma delimited is one of the main options. It seems like there must be a way to do this through an interface, command line, or something.
    Chris R Mead

    The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

  6. #6
    Senior Member
    Join Date
    Oct 2002
    Location
    England
    Posts
    368
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Comma Delimited files,

    Try attaching to an ODBC connection that uses the M$ Text Driver.

    I haven't tried it, but the ODBC Administrator dialog allows you to create a DSN that hooks in to .txt and .csv files.

    Regards
    Peat

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 6.67%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 08:30 AM.

Copyright BetaSoft Inc.