pradeepss
Last Activity: May 29 '07, 04:23 PM
Joined: Nov 21 '06
Location:
-
Its almost been 6 days and nobody replied to this post. please help me out here??? -
Imporint Excel Data into SQL with VB6
I have a problem importing the excel data in to SQL with VB6.
The problem is the cells which i am trying to import has a formula in it. And when i try to import it gives me 0 values. not sure how to import cells with formula as a value of the formula.
please help -
SQL Server does not exist or access denied
I have this connection string in my application:
con.ConnectionS tring = "Provider=SQLOL EDB;DRIVER={SQL SERVER};" _
& "SERVER=152.253 .145.23\General ;UID=test;PWD=r unme;DATABASE=t estserver"
the application runs fine on my computer (XP) but has some problem with Windows 2000 computer. I have tried different connection string but no luck. I have tried to ping the server from the problem computer... -
Well my file is about 6 MB in size with 400,000 record in each line. Its comma delimited with 7 fields.
the way i am looking at the table is this way. i have a parent table say A with 3 fields, with ID as primary key. A child table B is the table i want to insert the data (thats what the code is doing trying to insert the data) with primary key as DateID which is a foreign key for ID in A. So each record with ID in A corresponds to...Leave a comment:
-
Sorry but #iDate is a different file name which i close....Leave a comment:
-
sorry its semicolon delimited...and also crID is query done on the another table and is a statis value from a table. crID i get it correctly and is not an issue....Leave a comment:
-
Error while inserting data into table
I am developing an application which grab a comma delimited file and inserts them into a database. but while inserting it gives me an error. the code is below.
Do While Not EOF(iDrop)
Line Input #iDrop, iLine
iArray = Split(iLine, ";")
iArray(5) = Round(iArray(5) / 21.21, 0)
With rs
.AddNew
.Fields("ID") = crID
... -
great,
this definetely help? now how do i push the info in SQL table. i am using sql server 2000.
say i have a table: test in database: main
txt: 1,2,3,dump,E392 9H,-12,0,0,0
usnig your method i have them in array.
now how do create a connection to database, and push the info in the table test?
a sample code will definetely help...Leave a comment:
-
Yes its a comma delimited file....let me how to split them into array. then pick what i want to push it into a SQL table. I am using SQL server 2000....Leave a comment:
-
Parsing a text file and pick and dump into sql database
Guys,
I have a text file which is comma delimited and information. Each information is ended by end of line and started again with comma delimited i.e.
1,2,3,a,4
2,s,4,5,6,7,8,h
2,3,5,7,f,h,j,d ,d
What i need to do is pick a line and then put this in a array. then reference it like this:
ar(1)=1
ar(2)=2
.
.
.
ar(5)=4
now i dont...
No activity results to display
Leave a comment: