importing 4 different .txt files

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Try importing all separately and analyze for common characteristics. Edit
one table to accommodate all and then append.
 
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
 
Can not help you with images.

Rudodoo said:
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
Click to expand...
 
Back
Top