|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
May 21st, 2004, 10:48 AM
|
|||
|
|||
|
Connection string on a CSV file
Hello !
It is possible to connect a recordset from a .csv file ?? If yes, can anyone give me a little example  Thank you !
|
|
#2
May 21st, 2004, 11:14 AM
|
||||
|
||||
|
As this is the MsSQL (aka SQLServer) forum I would suggest to load the file into a table with DTS.
Otherwise, if you need to use a csv file as your database try posting in the appropriate scripting language forum or Google (which made for this link http://www.able-consulting.com/MDAC...BCDriverForText).
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins
|
|
#3
May 21st, 2004, 12:22 PM
|
|||
|
|||
|
Thanks a lot for the link you provided me.
 Sorry for the question in the wrong forum room. At first, I wanted to go by the DTS, but since my csv filenames are not the same everytime, my question was not relevant for here... Thanks again !
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Connection string on a CSV file |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
