View Single Post
  #3 (permalink)  
Old July 9th, 2009, 04:37 PM
Old Pedant Old Pedant is offline
Friend of Wrox
Points: 4,805, Level: 29
Points: 4,805, Level: 29 Points: 4,805, Level: 29 Points: 4,805, Level: 29
Activity: 50%
Activity: 50% Activity: 50% Activity: 50%
 
Join Date: Jun 2008
Location: Snohomish, WA, USA
Posts: 1,323
Thanks: 3
Thanked 70 Times in 69 Posts
Default

Caution: Note that the connection string specifies only the *DIRECTORY* where the file is located. Many people miss that point and try to use connection.open to get to the actual CSV file. You specify the file name in the SQL query.
Reply With Quote