Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
kpsqlteam
Starting Member
6 Posts |
Posted - 2012-11-28 : 03:48:50
|
Hi I have data in flat file like in below format100purus01 naidu2505 amt01101XXXX02 naidu2505 amt01 eeeee rrrrr yyyyHow can i insert this data into table using SQL server.very urgent.ThanksPurush |
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
|
srimami
Posting Yak Master
160 Posts |
Posted - 2012-11-28 : 06:22:10
|
Just to add one additional point to the above. By default, whenever you use Bulk Insert or Import/Export the datatypes will be of varchar. Make sure you use conversion factor or insert the data to another table with desired datatypes once loading is done from flat file. |
|
|
|
|
|