Geek Rant dot org

Fri 2005-03-04

F1 iTrip

Filed under: — tony @ 08:36

Driving to work yesterday my iTrip suddenly stopped working. Where there should have been The Podcast Network‘s The Jazz Show was static, and screeching. When I paused the show there was a high pitched tone. It lasted all the way from half way up the bridge, down by Albert Park Lake to Malvern.

It wasn’t until I was driving home that the solution presented itself.

The Australian Grand Prix is on at Albert Park Lake and they have set up a temporary FM radio station for attendees.

So, if your iTrip is tuned to around the 91.5 mark and you are travelling through inner city Melbourne over the next few days you may wish to dig out the iTrip CD you never thought you’d use again and reconfigure your pod or you can download your iTrip software from the Griffin Technology site.

Bookmark and Share

Inaccuracies reading Excel via ADO

Filed under: — daniel @ 06:48

Yesterday’s discovery with reading Excel via ADO and the ODBC Text Driver: numeric values may be wrong if it takes a guess that the column contains date fields.

The geeky detail (found in VB6SP5, Excel 2003, ADO 2.7, Jet Provider 4.0):

The text driver looks at the first few lines (configurable via the MaxScanRows setting or the Rows To Scan field in the DSN configuration box) to figure out what sort of data it is dealing with in each column. If there are numbers, it assumes the columns are numbers.

But if it sees dates, and sees no other data in the next few rows, then it assumes all the data in those columns are dates. If it gets further down to rows containing actual numbers, it still thinks it’s reading dates, and when it tries to convert the number to a date and back again, it causes a rounding error and ends up adding 1 to the final number.

In my case, the solution was to get the spreadsheets to contain zeroes (quite valid for the data being loaded) in the first few rows, instead of blanks. A little tricky, but it remains a good method for getting data out of Excel.

Bookmark and Share

26 queries. 0.363 seconds. Powered by WordPress