PL/SQL code to load data from a flat file into a MS-SQL Server table

Hi everybody,
I am very new to MS-SQL Server and I need the PL/SQL code to load data
from a flat file into a MS-SQL Server table. I would appreciate your
kind help ASAP. Thanks in advance.> I am very new to MS-SQL Server and I need the PL/SQL code to load data
> from a flat file into a MS-SQL Server table.
PL/SQL is the term used for Oracle SQL language extensions. Transact-SQL
(often abbreviated T-SQL) is used in Microsoft/Sybase SQL Server.
You can use BULK INSERT to import data directly from a text file. See the
Books Online for usage details.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Ratan" <ratan.nitrkl@.gmail.com> wrote in message
news:1194866854.016582.213720@.e34g2000pro.googlegroups.com...
> Hi everybody,
> I am very new to MS-SQL Server and I need the PL/SQL code to load data
> from a flat file into a MS-SQL Server table. I would appreciate your
> kind help ASAP. Thanks in advance.
>|||Thank you so much Dan. Could you please suggest me some good books?
On Nov 12, 5:30 pm, "Dan Guzman" <guzma...@.nospam-
online.sbcglobal.net> wrote:
> > I am very new to MS-SQL Server and I need the PL/SQL code to load data
> > from a flat file into a MS-SQL Server table.
> PL/SQL is the term used for Oracle SQL language extensions. Transact-SQL
> (often abbreviated T-SQL) is used in Microsoft/Sybase SQL Server.
> You can use BULK INSERT to import data directly from a text file. See the
> Books Online for usage details.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Ratan" <ratan.nit...@.gmail.com> wrote in message
> news:1194866854.016582.213720@.e34g2000pro.googlegroups.com...
>
> > Hi everybody,
> > I am very new to MS-SQL Server and I need the PL/SQL code to load data
> > from a flat file into a MS-SQL Server table. I would appreciate your
> > kind help ASAP. Thanks in advance.- Hide quoted text -
> - Show quoted text -|||> Thank you so much Dan. Could you please suggest me some good books?
I suggest Inside Microsoft SQL Server 2005: T-SQL Querying
(http://www.amazon.com/Inside-Microsoft-SQL-Server-2005/dp/0735623139).
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Ratan" <ratan.nitrkl@.gmail.com> wrote in message
news:1194874763.657788.164240@.o80g2000hse.googlegroups.com...
> Thank you so much Dan. Could you please suggest me some good books?
>
> On Nov 12, 5:30 pm, "Dan Guzman" <guzma...@.nospam-
> online.sbcglobal.net> wrote:
>> > I am very new to MS-SQL Server and I need the PL/SQL code to load data
>> > from a flat file into a MS-SQL Server table.
>> PL/SQL is the term used for Oracle SQL language extensions. Transact-SQL
>> (often abbreviated T-SQL) is used in Microsoft/Sybase SQL Server.
>> You can use BULK INSERT to import data directly from a text file. See
>> the
>> Books Online for usage details.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "Ratan" <ratan.nit...@.gmail.com> wrote in message
>> news:1194866854.016582.213720@.e34g2000pro.googlegroups.com...
>>
>> > Hi everybody,
>> > I am very new to MS-SQL Server and I need the PL/SQL code to load data
>> > from a flat file into a MS-SQL Server table. I would appreciate your
>> > kind help ASAP. Thanks in advance.- Hide quoted text -
>> - Show quoted text -
>|||Thank you so much.
On Nov 13, 9:36 am, "Dan Guzman" <guzma...@.nospam-
online.sbcglobal.net> wrote:
> > Thank you so much Dan. Could you please suggest me some good books?
> I suggest Inside Microsoft SQL Server 2005: T-SQL Querying
> (http://www.amazon.com/Inside-Microsoft-SQL-Server-2005/dp/0735623139).
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Ratan" <ratan.nit...@.gmail.com> wrote in message
> news:1194874763.657788.164240@.o80g2000hse.googlegroups.com...
>
> > Thank you so much Dan. Could you please suggest me some good books?
> > On Nov 12, 5:30 pm, "Dan Guzman" <guzma...@.nospam-
> > online.sbcglobal.net> wrote:
> >> > I am very new to MS-SQL Server and I need the PL/SQL code to load data
> >> > from a flat file into a MS-SQL Server table.
> >> PL/SQL is the term used for Oracle SQL language extensions. Transact-SQL
> >> (often abbreviated T-SQL) is used in Microsoft/Sybase SQL Server.
> >> You can use BULK INSERT to import data directly from a text file. See
> >> the
> >> Books Online for usage details.
> >> --
> >> Hope this helps.
> >> Dan Guzman
> >> SQL Server MVP
> >> "Ratan" <ratan.nit...@.gmail.com> wrote in message
> >>news:1194866854.016582.213720@.e34g2000pro.googlegroups.com...
> >> > Hi everybody,
> >> > I am very new to MS-SQL Server and I need the PL/SQL code to load data
> >> > from a flat file into a MS-SQL Server table. I would appreciate your
> >> > kind help ASAP. Thanks in advance.- Hide quoted text -
> >> - Show quoted text -- Hide quoted text -
> - Show quoted text -