Hi, thanks for taking the time to view my post.
I am using SQL SVR 2000 and I have built a DTS package which connects to an Access DB residing on another server and imports the data into a SQL table.
- First, on the SQL machine, I went thru the ODBC Data Source Admin to create a System DSN...
Ok, I got it to work. I had to tweak the excel sheet a bit. I had to add an additional column which I had to refer to the competency column and output it as a string. BTW - I tried a DTS import to a SQL Server table. The compentency table column had the same problem of null table values where...
I am not familiar with Excel. How do I go about displaying the data in that column as a string. I can see how to format it, tho "string" is not an option so I used "text". But I don't see where I can display it as "string". I am using Excel 2000.
Thanks again.
Shu
Hi All
I have my all my excel fields display just fine, except fields which have commas in them. In those cases ASP just seems to ignore it.
Here's the ASP:
-------------------
<%
Dim cn,rs,strSQL,cnt
Set cn =server.createobject("ADODB.Connection")
Set rs...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.