Viewing 15 posts - 76 through 90 (of 205 total)
Ron
Do you ask Stephen and me?
As Stephen says it depends.
Dim param1 etc as string or as date dependant on what content to be expected in the cell.
Look at...
October 10, 2009 at 2:39 am
Stephen great job.
I saw your example of code which is an approach i like and have one comment:
You open and close the ADODB.connection inside the loop which will cause extra...
October 9, 2009 at 11:33 am
LadyReader
Is it OK if I do it in VBA for you? I am bussy at the moment so please let me know if my help
is accepted.
//Gosta
October 9, 2009 at 8:27 am
Nice article as it focus on a common need:
"Basically people are comfortable with Excel that is why they use it."
Sometimes you only what figures or graphs to be presented without...
October 9, 2009 at 3:18 am
A small hint more.
If you want to remove all saturdays and sundays (not working days).
Put a column B besides A.
Write thursday for 2009-01-01, friday for 2009-01-02
and fill down.
All weekdays per...
September 23, 2009 at 12:44 pm
A smal hint.
Having the same situation I created the tally table with dates in Excel.
Set the format to Date for a column.
Start with in (sweden) 2009-01-01 row 1
2009-01-02 row 2.
Fill...
September 23, 2009 at 12:29 pm
Sai
If you are willing to abandon SSIS and use Excel VBA (ADO) you will have
complete control of what happens with the format. I don't think that MS has
done a great...
September 22, 2009 at 6:59 am
Hi
After having a lot of problems with SSIS and Excel I decided to skip SSIS in this
case. I save the Excelfile as a TAB separated textfile and use bulkinsert to...
September 22, 2009 at 6:16 am
Panks
"Can you please explain how to use the bcp to export data to csv."
Try Books on line or Google for:
bcp to export data to csv.
I got plenty 72 800 answers....
September 8, 2009 at 8:18 am
Why not create a DTS package if it is a one time job? Its very simple to transfer data (a table or more) from 2000 to 2005.
/Gosta
September 4, 2009 at 9:45 am
Do you have to do it in SSIS?
With Excel VBA OLEDB or ODBC it would be possible
to do it. If interested I can give some samples if you
provide...
September 4, 2009 at 8:45 am
Thank you Rob
I will just add one aspect.
"I have been repeatedly advised not to have SQL Server run Office automation"
You don't need to do that.
With Remote OLE DB you can...
August 20, 2009 at 1:48 am
Warren you are right.
"A last ditch effort would be to export all yout spreadsheets to a comma seperated file, or whatever yout choice, as individual text file then import those."
Importing...
August 13, 2009 at 1:02 am
"What was your solution to rendering the formula?"
In my case all formulas are parts of the Excel design
//Gosta
July 15, 2009 at 5:56 am
Is there anyone who can help me how to transfer the excel data into SQL server without using SSIS and DTS
You have to be more specific with your question....
July 9, 2009 at 6:12 am
Viewing 15 posts - 76 through 90 (of 205 total)