Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 TPS Files

Author  Topic 

rpc86
Posting Yak Master

200 Posts

Posted - 2008-06-16 : 21:54:45
Hi guys,

I use MS SQL 2000, and I'm new to our company. Our company uses Clarion as front-end with TPS (TopSpeed) database.

I just need to know if I can import TPS files to SQL Sever 2000.

Thank you.

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2008-06-16 : 23:11:43
are those the same as TPS reports? make sure you use the new cover sheet.


elsasoft.org
Go to Top of Page

rpc86
Posting Yak Master

200 Posts

Posted - 2008-06-16 : 23:15:54
Not a report. Clarion says TPS is the database. What New Cover Sheet ?
Go to Top of Page

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2008-06-16 : 23:36:25
just a little joke. http://en.wikipedia.org/wiki/TPS_report_(Office_Space)


elsasoft.org
Go to Top of Page

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2008-06-16 : 23:40:57
what is the format of the files? are the CSV or similar? if so you can import them with BCP or BULK INSERT.


elsasoft.org
Go to Top of Page

MinaGamble
Starting Member

1 Post

Posted - 2008-08-18 : 19:21:10
Hello,
I have TPS files that I would like to bring into SQL 2000 or SQL 2005. I'm not sure where to start if I don't have it in CSV format. Thanks.
Go to Top of Page
   

- Advertisement -