Avatar of Strif
Strif

asked on 

Import *.Dat File to SQL Table

Hello ! I'm getting some .dat files and when i try to open these files with notepad  looks like this:

02154  Mike      8594     08/05/2004   66
02155  James   8766    08/05/2004    01
02156  Nick      4874     08/05/2004   85
02157  Jack      8004    08/05/2004   49

i would like to add some of this values in a sql table which i have create and it has 3 Columns [ID,NAME,DATE]


ID             NAME          DATE
02154      Mike         08/05/2004  
02155     James      08/05/2004    
02156     Nick         08/05/2004  
02157     Jack        08/05/2004  

I'm  going to use this for a Bulk of .dat files and not only once
so, I'm searching for a automated way to do this

Thanks
Microsoft SQL ServerMicrosoft SQL Server 2005MySQL Server

Avatar of undefined
Last Comment
nmcdermaid

8/22/2022 - Mon