importing 4 different .txt files

[Guest]

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.

 

[Guest]

Try importing all separately and analyze for common characteristics. Edit
one table to accommodate all and then append.

 

[Guest]

That is what I am doing right now. Also, I need to create an images table
that links each image with its matching mls number. How should I create the
table for that. I am storing all images in an images folder

 

[Guest]

Can not help you with images.

That is what I am doing right now. Also, I need to create an images table
that links each image with its matching mls number. How should I create the
table for that. I am storing all images in an images folder