Importing .prt files to SQL
This is a discussion on Importing .prt files to SQL within the SQL Server forums, part of the Microsoft SQL Server category; --> What is the best way to import a structured .prt export file from an accounting package into SQl Server?? ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 03:53 AM
| ||||
| ||||
 Re: Importing .prt files to SQL chudson007@hotmail.com (Ciar?n) wrote in message news:<7f9b6870.0408100029.7289c726@posting.google. com>... > What is the best way to import a structured .prt export file from an > accounting package into SQl Server?? > > Tabs, Fixed col length??? The main options are bcp.exe (command-line tool), BULK INSERT (TSQL command), and DTS (ETL tool) - more details in Books Online. Simon      |
Linear Mode
