Hi, I'm new to Data and using it for a project that I need to pull data from an external data source. I've been following the instructions, but I feel a little lost with what's needed to get this working. Unfortunately, I already received a major error warning, so I wanted to pass it along:

[code}
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Number(255)) ) /*!40100 DEFAULT CHARACTER SET utf8 */' at line 19 query: CREATE TABLE nuisance_housing_data ( `Document Number` TEXT DEFAULT NULL, `Lien Type` TEXT DEFAULT NULL, `Detail` TEXT DEFAULT NULL, `Date Filed` TEXT DEFAULT NULL, `Date of Service` TEXT DEFAULT NULL, `House Number` TEXT DEFAULT NULL, `Dir` TEXT DEFAULT NULL, `Street` TEXT DEFAULT NULL, `Full Address` TEXT DEFAULT NULL, `City` TEXT DEFAULT NULL, `PIN` TEXT DEFAULT NULL, `Abatement Costs` TEXT DEFAULT NULL, `Added Costs` TEXT DEFAULT NULL, `Notes` TEXT DEFAULT NULL, `Assoc. Doc` TEXT DEFAULT NULL, `Assoc. Doc2` TEXT DEFAULT NULL, `More Notes` TEXT DEFAULT NULL, PRIMARY KEY (Document Number(255)) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in /var/aegir/production/includes/database.inc on line 550.
Error creating table.
Error creating table
[/code]

Thanks,
Ace