Recent content by versillus

Hi all, I want to ask a question. I have DTS local package in my sql server. I want to copy that package to another remote server which can use in case sql server in problem. The question can i copy that package like copy store procedure by generating script. Can somebody solve my problem?

MikeLewis, Thanks for your suggestion, I think i will try use DTS. I want to ask you about dtsrun. Can i run dtsrun in Visual Foxpro, which i save DTS package in file not in Sql.

I have already try DTS in sql. But apparently it create new table. In my case the table already exist, all i want to do is to add the record to that table. For the option No 2. How can i put row to row to sql table. How's the syntax ?

hi, I'm using visual foxpro 6 and Sql server 2000. Now i have excel file , i want to import this excel to sql table. For example i have excel file called icmstdt.xls and i want import this to sql table called icmstdt too. Can anyone help me to solve this problem.

but if i want combine with program in visual foxpro, how can i do that

I'm using ms sql 2000. I want to import excel file to table in sql. I want to use it in store procedure. Anyone can help me.

How can i get printer status, is it on or off, or paper out without using syntax sys in visual foxpro, I use visual foxpro 6.0

aircon, I try your syntax, but there's come error "Cannot find entry point OpenPrinter in the dll "

synapsevampire, how can i use 2 odbc connection in one report. I'm already used link database but the result is not what i expected

I have created report with crystal report and it's connect to SQL server using store procedure. I am using ODBC to connect sql server. The problem is My office has two server, and it's need two ODBC to connect it. Can crystal report using two kind of ODBC in the same report with same store...

My problem is i use 2 server.. one server is the main server, and the other one is local server in case there is problem with main server. Now I use report with 2 odbc too , one for main server and the other for local server. As i know in crystal report if i already set location for odbc main...

Can i create report with multiple server. for example i have two server. I also create 2 kind of odbc that refers to each server. How do I managed that 2 odbc to crystal report