![]() |
|
|
|
Liberal Prawn
|
Does anyone program Xcel Marcos - VB?
I hate microsoft -
That said - I have a client that wants to upload his tables into the databases that his website runs on (MySQL) - so I did the whole dashboard thing - but, unlike OpenOffice or iWork - when you define a column as being text in Excel - it doesn't put quotes around that field when you export to a csv file. I think I need to have him run a macro that would do that on just the columns that we need defined as text - if you don't put the quotes around it, it is blowing the whole database. I need columns A,B,C,D,E,F to be 'quoted' so the Database just posts them as text fields. Anyone here do this sort of stuff?
__________________
'Such are promises - All lies and jest - Still a man hears what he wants to hear - And disregards the rest. Lie la lie, lie la lie la lie la lie' Paul Simon '87 Black Targa "Welpe" • '93 Cadillac Allante "Amante" • Various other boring cars Last edited by foxpaws; 02-12-2012 at 09:17 AM.. |
||
![]() |
|