How can I create a table from a text file with SQL Server

[Guest_imported]

Hello I`d like to Know how I can create a table from a text file,I think that I have to import a text file but I don't Know how I can do it.
Thanks in advance

 

[Guest_imported]

maybe try creating an instance of the filesystemobject inside of SQL

 

[THoey]

If you are using Oracle, you need to create the table structure first and then you can use SQL*Loader. I'm going to save the rest of the details until I find out which RDBMS you are using...


Terry M. Hoey
th3856@txmail.sbc.com

Ever notice that by the time that you realize that you ran a truncate script on the wrong instance, it is too late to stop it?

 

[BootMeUp]

If you're using SQLServer 7.0 you can use Data Transformation Services. Either use the Wizared on mmc tool bar or 'All tasks'|'Import' (right click) from the database target. It will guide you in setting up import. You can then save the VB code - if you're doing this in a program and use/modify that code.
See BOL for more info.