-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: VaibhavModak
Message 5 in Discussion
Hi, You can use the SQL BULK INSERT statement to copy data from your data file to the
SQL Server Table. Just execute the following query to complete the data import from
the data file to the table. strQuery="BULK INSERT " & sTableName & " FROM ' " &
sFileName & " ' " & _ "WITH ( " & _ "DATAFILETYPE =
'char', " & _ "CODEPAGE = 1250, " & _ "FIELDTERMINATOR
= ';' , " & _ "ROWTERMINATOR = '\n' " & _ ")" Here,
sFileName = Name of your data file (with path), ' You can use the File Open
Dialog to get the new path, (if as you say that it changes daily). sTableName = Your
table name, FIELDTERMINATOR = Semicolon (;) ' You can replace it
with the Terminator char that you are using. ROWTERMINATOR = newline character (\n)
' You can replace it with the Terminator char that you are using. HTH,
Regards, Vaibhav Modak
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/MumbaiUserGroup/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
