I have just learned SQL and have started using it. My question, is there a way to create a table using SQL from a flat file, such as a text file? I would think you could use insert but I can't find anything to back up this idea.
Thanks
Printable View
I have just learned SQL and have started using it. My question, is there a way to create a table using SQL from a flat file, such as a text file? I would think you could use insert but I can't find anything to back up this idea.
Thanks
If your flat file is properly formatted (comma/tab delimited or fixed length column, etc) you can use bcp or BULK INSERT if you are using SQL Server. For Oracle you can use SQL Loader.
What's the SQL Loader? Is that a different tool for SQL? Can you give me a sample of the syntax?
SQL Loader is an Oracle tool, you can check technet.oracle.com to see the syntax.
It only works with Oracle.
thanks for the info, i just got my Oracle disks, so i'll have to check that out. Is there anything special for Sybase? We, a friend and I are trying to figure out a way to create the tables from the flat file for Sybase. Currently it gets done in Access and connect to Sybase, and this takes awhile.
Check BCP for Sybase