I am creating a MLS database for real estate agents and my data source
consist of 4 different .txt files.  that I have labeled below

1.  Residential

2.  Multi-Family

3.  Commercial

4.  Listing

I am creating this database for a web-site I developed in Dreamweaver MX
2004 and I am using coldfusion MX7 to access the database.

Someone told me that it would be best if I created just 1 table within the
database that contained all the text data.  However, I am having trouble
importing the data that I need from each text file.

I alway receive an error saying certain fields aren't labled in the first
format I created when I try to import the data from the second .txt file.

I need certain attributes from each .txt file that isn't displayed on
others.