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 |
|
alanhuro
Starting Member
34 Posts |
 Posted - 2008-05-29 : 12:24:58
|
| Hi.We have a machine in our plant that runs the chemcial analysis for the sample taken every 15 min. The software came with the machine was designed to store the data into a dat file. Each column in the dat file was separate by a tab. I try to find a way to automatically import the data from the dat file into the SQL server. I know the solution is out there but don't know where to find it. If you know a way please help me out. I'm very appreciated for your help. ThanksAlan |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-29 : 12:44:44
|
| You can use Export/Import wizard tool in your Enterprise manager.Refer link about how to lauch export/import wizard:-http://www.aspfree.com/c/a/MS-SQL-Server/Using-Data-Transformation-Services-Part-1/1/ |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
|
|
|
|
|
Automatic Import data into SQL database Help