Dear,

I want to capture a date field from CSV file to the table
(the CSV file have one date field only). But the table data
(another field) import from another CSV file. How can i
import the data field from CSV file and fit in the table?

Many Thanks
John

OK

From your explanation I read that you have 2 text files. One contains a
data that you want and the rest of the data comes from the other file.

They must be joined somehow by key otherwise how do you know which date goes
with which row?

Import the text files into their own working tables. Use TSQL then to
manipulate these tables

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"John" <anonymous (AT) discussions (DOT) microsoft.com> wrote