exisiting table(no data) via syntax SQL. I am just not
sure of the code.
could it be something like:
INSERT MY_FILE.TXT INTO MY_TABLE
I really appriciate your helpThis is a multi-part message in MIME format.
--=_NextPart_000_00E3_01C34C6A.735A2DC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Check out BULK INSERT or bcp in the BOL.
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"jon" <jon@.mybossisken.com> wrote in message =news:014701c34c8b$573349d0$a401280a@.phx.gbl...
I am looking to import a text file into a already exisiting table(no data) via syntax SQL. I am just not sure of the code.
could it be something like:
INSERT MY_FILE.TXT INTO MY_TABLE
I really appriciate your help
--=_NextPart_000_00E3_01C34C6A.735A2DC0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Check out BULK INSERT or bcp in the BOL.
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"jon"
--=_NextPart_000_00E3_01C34C6A.735A2DC0--
No comments:
Post a Comment