August 4, 2004 at 1:43 pm
How can I import a file with .CPT extension in SQL 2000 server?
Any help would highly be appreciated..
Thanks.
August 4, 2004 at 3:41 pm
The extension is not nearly as important as the format. What format is the file? What application created it? Is it a text file? comma delimited, tab delimited?
Steve
August 5, 2004 at 12:28 am
And I'm pretty sure you can't import a Corel Photopaint file into SQL Server (ho hoh ho)
The systems fine with no users loggged in. Can we keep it that way ?br>
August 5, 2004 at 2:06 am
I can recommend a utility called DBMS copy.
The company that wrote it has been bought out by the SAS institute who sell it through their dataflux subsidiary.
August 5, 2004 at 2:21 am
Another migration tool that I have used in the past is Datawatch Monarch. I'm not sure what it can do these days but at the time I was using it the product was designed for taking a Mini/Mainframe spool file and extracting data from it into a number of spreadsheet/database formats.
It could also perform its own calculations and summary operations on the raw data and dump the results into a database/spreadsheet format.
Last thing I heard the package could also read and extract data from HTML files.
At the time I was using it the package was the sort of thing that an accountant would whinge like hell about paying for it, but 1 nanosecond out of the box it had paid for itself a million times over.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply