- CSV Files -

Results 1 to 3 of 3

Thread: - CSV Files -

  1. #1
    EggMan Guest

    Default - CSV Files -

    Hi Guys, <BR><BR>I have a CSV file in the style of:<BR>ID,Date,<BR>"1","07/09/2001"<BR>"2","07/09/2001"<BR>....<BR><BR>How would I go about (1) trying to parse the csv file into the appropriate varables and the (2) ultimatly inserting this infomation into a database.<BR><BR>Thanks in advance

  2. #2
    Join Date
    Dec 1969

    Default RE: - CSV Files -

    Pseudo-code.<BR><BR>1) Load the file in using the FileSystemObject (FSO). For more information check http://msdn.microsoft.com/scripting<BR>2) Split the information up by vbcrlf (line break), so you have an array of lines.<BR>3) Loop through this array and split each line by commas into the appropriate sections. (You may need a regular expression to ignore commas inside quotes).<BR>4) Use the information as you will.<BR><BR>Any help?<BR><BR>Craig.

  3. #3
    Egg MAn Guest

    Default ManyThanks.


Posting Permissions

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