Click here to Skip to main content
15,920,438 members
Home / Discussions / Database
   

Database

 
AnswerRe: How do you import a CSV file into MS SQL? Pin
Mike Dimmick18-Mar-06 11:17
Mike Dimmick18-Mar-06 11:17 
AnswerRe: How do you import a CSV file into MS SQL? Pin
Jorge Novo18-Mar-06 15:19
Jorge Novo18-Mar-06 15:19 
GeneralRe: How do you import a CSV file into MS SQL? Pin
mcljava19-Mar-06 18:02
mcljava19-Mar-06 18:02 
QuestionCrystal Reports.NET, Push method, Login failed Pin
Glenn E. Lanier II17-Mar-06 9:27
Glenn E. Lanier II17-Mar-06 9:27 
QuestionBLOB image data conversion Pin
marianguru17-Mar-06 8:45
marianguru17-Mar-06 8:45 
QuestionADO.NET 2.0 best online comprehensive source for information Pin
LuluSailor17-Mar-06 7:03
LuluSailor17-Mar-06 7:03 
AnswerRe: ADO.NET 2.0 best online comprehensive source for information Pin
Dave Kreskowiak17-Mar-06 16:45
mveDave Kreskowiak17-Mar-06 16:45 
QuestionOleDbConnection & Network drive Pin
hasanali0017-Mar-06 4:10
hasanali0017-Mar-06 4:10 
Hi
I want to access a .csv file on a network drive.

I am using the following code:

string filename = "csvsample.csv";<br />
<br />
	string cs = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Y:/csv/;Extended Properties='text;HDR=Yes;FMT=Delimited'";<br />
<br />
				OleDbConnection  objOleDBConn = new OleDbConnection(cs);<br />
				objOleDBConn.Open();<br />
				sqlSelect =	"select * from ["+ filename+"]"; <br />
OleDbDataAdapter objOleDBDa = new OleDbDataAdapter(sqlSelect,objOleDBConn);


However, I am getting "'Y:/csv/' is not a valid path. " error.

Y is a network drive AND the file does exist on Y:/csv/ folder.

Can anyone help me, please.

Thanks
AnswerRe: OleDbConnection & Network drive Pin
jonathan1517-Mar-06 5:24
jonathan1517-Mar-06 5:24 
GeneralRe: OleDbConnection & Network drive Pin
hasanali0017-Mar-06 6:03
hasanali0017-Mar-06 6:03 
GeneralRe: OleDbConnection & Network drive Pin
Colin Angus Mackay17-Mar-06 7:04
Colin Angus Mackay17-Mar-06 7:04 
QuestionHow Large Can SQL Server 2005 Database Be? Pin
Mike Puddephat17-Mar-06 3:26
Mike Puddephat17-Mar-06 3:26 
AnswerRe: How Large Can SQL Server 2005 Database Be? Pin
Colin Angus Mackay17-Mar-06 7:01
Colin Angus Mackay17-Mar-06 7:01 
GeneralRe: How Large Can SQL Server 2005 Database Be? Pin
Mike Puddephat18-Mar-06 5:08
Mike Puddephat18-Mar-06 5:08 
QuestionSQL compatibility Pin
tanpanjang16-Mar-06 21:29
tanpanjang16-Mar-06 21:29 
AnswerRe: SQL compatibility Pin
Colin Angus Mackay17-Mar-06 1:40
Colin Angus Mackay17-Mar-06 1:40 
Questionstoring the result of exec (sqlQuery ) into a variable Pin
sandeep kumar pundhir16-Mar-06 20:15
sandeep kumar pundhir16-Mar-06 20:15 
AnswerRe: storing the result of exec (sqlQuery ) into a variable Pin
Colin Angus Mackay16-Mar-06 20:32
Colin Angus Mackay16-Mar-06 20:32 
GeneralRe: storing the result of exec (sqlQuery ) into a variable Pin
sandeep kumar pundhir20-Mar-06 18:14
sandeep kumar pundhir20-Mar-06 18:14 
Questioncustomer defined data fields Pin
econner16-Mar-06 16:16
econner16-Mar-06 16:16 
AnswerRe: customer defined data fields Pin
Muhammad Jawad17-Mar-06 1:34
Muhammad Jawad17-Mar-06 1:34 
QuestionSet SQL_ATTR_CURSOR_SCROLLABLE return error Pin
nhuythanh16-Mar-06 16:01
nhuythanh16-Mar-06 16:01 
QuestionSQL Server does not allow remote connections error Pin
tanpanjang16-Mar-06 10:37
tanpanjang16-Mar-06 10:37 
AnswerRe: SQL Server does not allow remote connections error Pin
Colin Angus Mackay16-Mar-06 12:07
Colin Angus Mackay16-Mar-06 12:07 
GeneralRe: SQL Server does not allow remote connections error Pin
tanpanjang16-Mar-06 17:31
tanpanjang16-Mar-06 17:31 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.