|
Thread for interesting bits and pieces of stuff...
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
From the Microsoft Forum by Paul Clement:
The following will create the table in Access during the import:
SELECT * INTO [Data] FROM
[Excel 8.0;DATABASE=E:\My Documents\Test.xls;HDR=No;IMEX=1].[Sheet1$]
The below statement operates on an existing table in Access:
INSERT INTO [Data] (Col1, Col2, Col3, Col4) SELECT F1, F2, F3, F4 FROM
[Excel 8.0;DATABASE=E:\My Documents\Test.xls;HDR=No;IMEX=1].[Sheet1$]
In each example above the connection should be made to the Access database in order to perform the import.
Found this be potentially helpful when having to deal with any Access projects that require bulk insertion of data. Did a test on the first SQl statement with an Excel spreadsheet containing 72 columns and 65535 rows of test data. Took no more than about 3 seconds on the Toshiba Laptop.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Smart Client Composite UI Application Block[^], suggested by Pete O'Hanlon, looks to be very useful on some upcoming projects
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Windows Vista 32 Bit and 4GB Ram[^]
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Blue Moon Authentication[^] sounds like an interesting approach at verifying if a user is really him/herself.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Programming Blips I find helpful, for me, maybe for you, too
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
There is a CPian who has been asking math questions in the math forum how to implement the equivalent Excel functions in C#. Not sure if Office Interop Libraries are allowed in his project, but here is using the FDIST function in VB.NET:
<code>
Dim myExcel As New Microsoft.Office.Interop.Excel.Application
' myResult holds the result from FDIST(12.222,7,4) = 0.0145705260672057
Dim myResult As Double = myExcel.WorksheetFunction.FDist(12.222,7,4)
</code>
And the C# version:
<code>
Microsoft.Office.Interop.Excel.Application myExcel =
new Microsoft.Office.Interop.Excel.Application();
double myResult = myExcel.WorksheetFunction.FDist(12.222,7,4);
</code>
This can be verified in Excel by typing into the A1 cell, =FDist(12.222,7,4) ,
and you should get 0.0145705260672057
Must make sure add a reference in the project to the Excel Object Library depending on the version of Excel to be used. Client computers will need to have Office installed in order to use this code snippet.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Spent a good part of the evening last night getting rid of the beta of Silverlight 2 from the laptop. Cleaned up a few other things off the machine. Installed the newest version of Silverlight and appropriate tools for VS2008.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Set up a blog on Wordpress now. Tired of people voting down any blogging I do here.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Here are sigs (signatures) that I have collected over time here at CP...
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
"If you try to write that in English, I might be able to understand more than a fraction of it." - Guffa
|
|
|
|
|
"I'd like to help but I don't feel like Googling it for you."
|
|
|
|
|
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
"You posted your question here, indicating that you're so thick you couldn't find the VB Forum if it was licking your bung hole." - John Simmons / outlaw programmer
"Try asking what you want to know, rather than asking a question whose answer you know." - Christian Graus
|
|
|
|
|
"I've seen more information on a frickin' sticky note!" - Dave Kreskowiak
|
|
|
|
|
"It's only that urgent if you have to pee..." - Dave Kreskowiak
|
|
|
|
|
"Find it your bloody self - immediately!" - Dave Kreskowiak
"Find it your bloody self - immediately!" - Dave Kreskowiak
|
|
|
|
|
"That's no moon, it's a space station." - Obi-wan Kenobi
|
|
|
|
|
"too much daily WTF for someone..." - Anton Afanasyev
|
|
|
|
|
"The early bird may get the worm, but the second mouse gets the cheese" - anonymous, found in Uncle John's Bathroom Reader
|
|
|
|
|
"But your mind is too small and simple to understand anything other than fart jokes." - leckey
|
|
|
|
|
"Try asking what you want to know, rather than asking a question whose answer you know." - Christian Graus
"Try asking what you want to know, rather than asking a question whose answer you know." - Christian Graus
|
|
|
|
|
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
"I really like comments where I don't have to answer stupid questions" - stfx
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Light ORM Library for .NET[^] is very good. Have a strong interest in ORM tools and this one isn't bad at all.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|