Import text file specification

[toekneel]

I'm working with Microsoft Access 2000 Project (*.adp) as the front end of a SQL Server 2000 db. I need to import a text file with import specifications, which was easily done in *.mdb. Problem is that the *.adp does not allow you to use the same interface to establish your specs. The TransferText command is looking for a schema.ini file to use as the import specification, housed in the same folder as the *.adp file. I find no such file in searches of existing Access 2000 file areas. I need to find what that schema should look like so I can build it and then utilize it in importing my text file. Any help from SQL Server gurus who discovered that moving to SQL Server from Access just wasn't quite as easy as you'd always been told?

Thanks!

Tony L

 

[coders4hire]

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcjetsdk_98.asp

Does this help?


---
doug@coders4hire.com

http://www.coders4hire.com

http://www.payraisecalculator.com

http://www.cliintel.com