Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Exporting to SQL table
0 views
Skip to first unread message
James McCracken
May 18, 1999, 3:00:00 AM5/18/99
to
I'm looking for information on table formats for SQL tables. We have an
application that uses FlashFiler databases and we want to provide the
ability for our clients to export data from our FlashFiler tables directly
to a SQL formated table without having to convert it. I guess I need to know
what details are needed for SQL to recongnise the exported table as a valid
SQL table...
application that uses FlashFiler databases and we want to provide the
ability for our clients to export data from our FlashFiler tables directly
to a SQL formated table without having to convert it. I guess I need to know
what details are needed for SQL to recongnise the exported table as a valid
SQL table...
Regards, J. McCracken
Neil Pike
May 18, 1999, 3:00:00 AM5/18/99
to
James,
SQL can't access "tables" in flat files directly. Use BCP/DTS/BULK INSERT to take the data from the flat file and
stick it in a table/
Neil Pike MVP/MCSE. Protech Computing Ltd
(Please post ALL replies to the newsgroup only unless indicated otherwise)
For SQL FAQ entries see
http://go.compuserve.com/sqlserver (library 1) - latest stuff is always here
www.ntfaq.com/sql.html
http://www.swynk.com/faq/sql/sqlserverfaq.asp
0 new messages