Pelican Parts Forums

Pelican Parts Forums (http://forums.pelicanparts.com/)
-   Off Topic Discussions (http://forums.pelicanparts.com/off-topic-discussions/)
-   -   Does anyone program Xcel Marcos - VB? (http://forums.pelicanparts.com/off-topic-discussions/657586-does-anyone-program-xcel-marcos-vbulletin.html)

foxpaws 02-12-2012 08:54 AM

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?


All times are GMT -8. The time now is 11:35 AM.

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


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