Results 1 to 3 of 3

Thread: CSV Recordset

  1. Jul 9th, 2001, 07:24 AM #1
    josmond
    josmond is offline

    Thread Starter
    Lively Member
    Join Date
    Sep 1999
    Location
    Somerset, UK
    Posts
    93

    CSV Recordset

    I have managed to create a recordset from a csv file that live locally on my well 'ard drive - using the 'Microsoft Text Driver' and this works fine.

    My question is can you read a csv that is not on the local drive

    e.g. http://www.yourdomain.com/myfile.csv


    ????


    Any Ideas??
    Reply With Quote Reply With Quote
  2. Jul 9th, 2001, 10:42 AM #2
    JoshT
    JoshT is offline
    Black Cat JoshT's Avatar
    Join Date
    Nov 2000
    Location
    WNY, USA
    Posts
    4,032
    You would have to use Winsock or a similar method to get the text file off the web and save it locally, then you could manipulate it.
    Josh
    Get these: Mozilla Opera OpenBSD
    I have books for sale: "MCSD in a Nutshell" and "VB Distributed Exam Cram" - PM me for details. Will also trade for a decent ATX Pentium 2 MB/CPU/RAM combo.
    Reply With Quote Reply With Quote
  3. Jul 9th, 2001, 12:48 PM #3
    monte96
    monte96 is offline
    Frenzied Member monte96's Avatar
    Join Date
    Sep 2000
    Location
    Somewhere in AZ
    Posts
    1,379
    If you have Excel installed, it will try to open it in the browser unless you do it the way JoshT said..
    oOOo--oOOo
    __/\/\onte96
    oOOo--oOOo
    Senior Programmer/Analyst
    MCP
    [email protected]
    [email protected]


    Your results may vary.. some restrictions may apply.. pricing and participation may vary.. not available in all states.. professional driver closed course..quantities limited..
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width