Welcome to the first ever Coding Pad Blog Contest!! We’re giving away some stuff – so read on!
What’s the occasion? – None really, just thought it would be cool to celebrate the MODx Content Management Framework/System
What’s my goal? – To get more exposure for MODx and to get more people interested in MODx and it’s [...]
Entries Tagged as 'Data and Databases'
Win a Copy of the MODx Web Development book and more – Blog Contest
April 9th, 2009 · 46 Comments · Data and Databases, Giveaways, MODx
Tags: Blog Contest·Book·Free·MODx
A delimiter with non-delimiter uses during data import in Excel
February 13th, 2008 · 2 Comments · Data and Databases
I ran into an interesting situation the other day when trying to import some data into Excel. I had a text file with words and definitions that I needed to have in two columns in Excel, one for the word and one for the definition.
The words and their definitions were separated by a hyphen [...]
Tags:
Importing large CSV files into Excel Using a Macro
February 5th, 2008 · No Comments · Data and Databases, Useful Links and Resources
In response to my post on importing large files into Excel by first splitting them, one of my readers, JP pointed out to me that you can bypass the splitting step by using a VBA macro to do the import.
As you may know, Excel has a cut off of 65,536 rows, and so if you [...]
Tags:
Large csv file? Download the CSV Splitter
November 1st, 2007 · 2 Comments · Data and Databases
If you have a large csv file that you have tried to open in Excel, you know how troublesome that can be, because Excel is limited in the number of rows and columns of data it can handle – 65,536 rows of data and 256 columns per worksheet. Truncation of rows or columns in excess [...]
Tags:
Converting csv to sql using php
September 24th, 2007 · 4 Comments · Data and Databases, PHP
In previous posts we’ve discussed getting your csv files into sql format using different methods. I walked you through the process from csv to sql using HeidiSQL and PHPMyAdmin. I then did a follow up on how to import a large csv file into a MySQL database using the MySQL command prompt. In all [...]
Tags:
