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 |
|
Lester Vincent
Starting Member
22 Posts |
 Posted - 2003-11-14 : 07:42:07
|
| Hi people. Yesterday, I upsized an Access2000 app, using the upsizing wizard. Apart from having to switch from DAO to Ado Code, Found that "DoCmd.TransferText acImportDelim, 'ImportTextFilesFormatSpec', 'MyTable', 'MyTextFile', False" no longer worked. The import format file was deleted, and the "Save Format Specs" feature was no longer available. MY app depends heavily on being able to loop throuhg a list of delimited text files and pull the data into an existing table with 2 fields ("LineNo" (int) and "Text" (255 chars)). I have not written any Stored Procedures or Transact-SQL views, but expect the solution is in creating a Stored Procedure, with SQL like "INSERT INTO (TableName) ...Would appreciate any help that is offered.Regards,Lester Vincent |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-11-14 : 07:47:20
|
| BULK INSERT, bcp, and DTS can all import text files into Access or SQL Server (bcp and DTS also export) There are a number of ways of importing an entire folder of text files, here's one method:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=24371If you search the forums for "import multiple files" you'll find more threads. Also check Books Online for "bcp", "BULK INSERT", and "DTS". |
 |
|
|
|
|
|
|
|
Importing Lost after Upsizing Access 2000