Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
carrieh
Starting Member
9 Posts |
 Posted - 2006-04-13 : 12:15:16
|
| Hi all, I receive data via FTP to our webserver nightly as .txt files and .dic (if anybody is familiar with idx realtor websites, that's what this data is). I've learned recently that I'm not going to be able to use Access to import or link to this data, so I'm trying to get my feet wet with SQL. I have been practicing importing text files into SQL db, but I notice that the dts imports everything as varchar 8000, and that you can edit that. I've got a .dic file that accompanies every .txt file that contains definitions of each fieldname, fieldtype & length & I was wondering how to import that data as well, without having to manually retype everything. I would be happy to email these text files to anybody willing to take a look.Thanks,Carrie |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2006-04-13 : 12:26:46
|
| I am not familar with .dic or idx realtor site, but I do know in access 2000/2003, when you try to link to certain dbase file, it ask you for index file, and after you point to the index file, it will incorporate them together.On the sql side, my expereice has been to prebuild the table based on the definition file, then map the text file field by field to this table. That works under AS400 db2. |
 |
|
|
carrieh
Starting Member
9 Posts |
Posted - 2006-04-13 : 13:34:27
|
| The .dic file must be an index file then. Can it be used at all when importing text files, or must it be done manually? |
|
|
|
|
|
|
|
|
Importing .txt files with separate definition file