PDA

View Full Version : ODBC Exports to Metric Only?



dgreen.49364
2007-03-15, 03:32 PM
So I've been playing with the ODBC data export. Got reams of paper to show for it. I thought it was all pretty useful information until I came to realize that all of my lengths and areas are wrong. Then I discovered that ODBC exports to metric ONLY.

Why?

Are there no work arounds for this? Is there nothing I can do? What a total waste of time!

david.kingham
2007-03-15, 03:36 PM
http://forums.augi.com/showthread.php?t=19990&highlight=odbc+metric

dgreen.49364
2007-03-15, 03:59 PM
OK

"Use conversion functions in whatever app you are viewing the data to convert to the units you like."

What does that mean? I'm not a database guy. I barely know how to open an Excel spreadsheet.

Dimitri Harvalias
2007-03-15, 11:05 PM
If you export to Excel you can simply add another column to the spreadsheet that would contain a formula to multiply the value in column XXX (say length) and by the correct conversion value (meters to feet for example)

This can be easily set up in any application into which you are importing your ODBC data