Re: Passing text file to SQL Server
From: Bryan Martin (uce_at_ftc.gov)
Date: 02/23/04
- Next message: David Sworder: "Is 'Mutex' the only machine-wide sync mechanism?"
- Previous message: Chris: "Passing text file to SQL Server"
- In reply to: Chris: "Passing text file to SQL Server"
- Next in thread: Chris: "Re: Passing text file to SQL Server"
- Reply: Chris: "Re: Passing text file to SQL Server"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 23 Feb 2004 15:15:12 -0500
You should look at bulk insert in the Books online help.
"Chris" <anonymous@discussions.microsoft.com> wrote in message
news:0684D883-C1D7-4B50-85AA-3F5A71B04DF7@microsoft.com...
> Hi,
> I need to pass the entries in a text file to corresponding tables in a
database. Can I pass the entire text file to a stored procedure or can I
write a VB.NET procedure to pharse the file and pass the data to the
database? This is a sample of the text file
>
>
> 1120,011522169050,01,+0000001,031221,0005.95,2003,8331308,20031222
> 9924,014305689050,01,+0000001,031221,0005.95,2003,8331308,20031222
> 1883,012152869050,01,+0000001,031222,0005.95,2003,8331308,20031223
> 1896,017202869050,01,+0000001,031221,0005.95,2003,8331308,20031222
> 1896,072211119050,01,+0000001,031222,0005.95,2003,8331308,20031223
> 1908,028502869050,01,+0000001,031221,0005.95,2003,8331308,20031222
>
> Can you show me some sample code?
>
> Thanks
- Next message: David Sworder: "Is 'Mutex' the only machine-wide sync mechanism?"
- Previous message: Chris: "Passing text file to SQL Server"
- In reply to: Chris: "Passing text file to SQL Server"
- Next in thread: Chris: "Re: Passing text file to SQL Server"
- Reply: Chris: "Re: Passing text file to SQL Server"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
