sql server (microsoft): import data from .txt file to database table -- sql server (microsoft)

import data from .txt file to database table

achen NO[at]SPAM comverge.com
11/25/2003 11:24:29 AM

sql server (microsoft):

Hi All,
I saved "select * from xxx where id=234" query on a remote server in a .txt file.
Is there an easy way to "import" the data in the .txt file
to a table with the same fields on my PC ?

Re: import data from .txt file to database table

mountain man
11/26/2003 2:31:29 AM

1) Do you have SQL Server?
2) Have you checked the Import module?
3) You'll need to ascertain the appropriate format.txt you have (in the
Import process [wizard])
4) You may need to add in the same format the field names in the first row
if not there.
5) Alternatively experiment doing this via an intermediate import to Excel

In general you can "import" anything ...

[quoted text, click to view]