Pelican Parts
Parts Catalog Accessories Catalog How To Articles Tech Forums
Call Pelican Parts at 888-280-7799
Shopping Cart Cart | Project List | Order Status | Help



Go Back   Pelican Parts Forums > Miscellaneous and Off Topic Forums > Off Topic Discussions


Reply
 
LinkBack Thread Tools Rating: Thread Rating: 2 votes, 5.00 average.
Author
Thread Post New Thread    Reply
Liberal Prawn
 
foxpaws's Avatar
 
Join Date: Sep 2010
Location: near the kingdom of Boulder, CO
Posts: 20,883
Garage
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..
Old 02-12-2012, 08:54 AM
  Pelican Parts Catalog | Tech Articles | Promos & Specials    Reply With Quote #1 (permalink)
Reply


 


All times are GMT -8. The time now is 01:04 PM.


 
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
Search Engine Optimization by vBSEO 3.6.0
Copyright 2025 Pelican Parts, LLC - Posts may be archived for display on the Pelican Parts Website -    DMCA Registered Agent Contact Page
 

DTO Garage Plus vBulletin Plugins by Drive Thru Online, Inc.