-
Creating tables from text files?
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.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|