Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    6

    Question Unanswered: Parameterized Stored Procedure for import/export txt file ??

    Hi guys,

    MS Access version: 2000

    I try to rewrite the below two stored procedures into "Parameterized" ones(parameters are "FilePath" and "FileName" for import/export from text file) but failed.

    These two SQL statements are for text file import, very quick !

    Can anyone help me with this?
    ------------------------------------------------------------
    "SELECT * INTO [TEXT;Database=C:\].[Export1.txt] FROM [Publishers]"
    "INSERT INTO TN_Publisher SELECT * FROM [TEXT;Database=C:\].[Import1.txt]"
    ------------------------------------------------------------

    Thank you!

    Regards,

    Stanley
    Last edited by StanONE; 10-13-04 at 06:02.

  2. #2
    Join Date
    Apr 2004
    Posts
    6
    anybody ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •