User Name Password Register
DaniWeb IT Discussion Community
Home
Forums
Tutorials
Code Snippets
Blogs
Link Directory
White Papers
All
•
•
•
•
What is DaniWeb IT Discussion Community?
DaniWeb is a massive community of 402,506 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,841 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Join our community!
•
•
•
•
Showing results 1 to 6 of 6
Search took 0.01 seconds. Posts Made By: tatini
Save these search results for 24 hours
Forum: MS SQL Nov 2nd, 2007
Replies: 15
Views: 9,633
Posted By tatini
Re: Get data out of excel file stored as an image

Higa, you are right. But in my case, the excel sheet will have only two columns and I know for sure it doesnt cause any problems.
Now I have a new problem. Its about sheet names in the excel. I dont...
Forum: MS SQL Nov 2nd, 2007
Replies: 15
Views: 9,633
Posted By tatini
Re: Get data out of excel file stored as an image

i am changing the excel column to varchar before i actually write to the sql table.
i used this earlier:

INSERT INTO table(c1,c2)
SELECT Code1,Desc
FROM...
Forum: MS SQL Nov 2nd, 2007
Replies: 15
Views: 9,633
Posted By tatini
Re: Get data out of excel file stored as an image

hmm..will let you know my findings or what ever i do. thanks man. repped.
Forum: MS SQL Nov 2nd, 2007
Replies: 15
Views: 9,633
Posted By tatini
Re: Get data out of excel file stored as an image

All is done and working but when i import the data from the excel to sql table, i see a change in the data.
the excel sheet has a column with numbers stored as text. they have a 0 as the first...
Forum: MS SQL Nov 2nd, 2007
Replies: 15
Views: 9,633
Posted By tatini
Re: Get data out of excel file stored as an image

thanks a lot.
Started on the same path before posting that question. Acheieved the result in a similar way.
Forum: MS SQL Nov 2nd, 2007
Replies: 15
Views: 9,633
Posted By tatini
Re: Get data out of excel file stored as an image

Is there any way we can specify the file name and location in Datasource as a variable?

Like can we replace the following with a variable?

'Data Source="D:\spreadsheets\test.xls";Extended...
Showing results 1 to 6 of 6

 
Advertising Opportunities on DaniWeb
Contact Us - Newsletter Archive - Sitemap - Privacy Statement
All times are GMT -4. The time now is 5:49 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC