Hi,

     I am trying to read file (C:\Test.txt) and read it line by line and store the values into a MS access database table name TEMP
ERROR : Run Time Error 3134
TEMP
Field = EMPLOYEE (Primary Key)

i have tried following code

Dim sFileText, strPictureFilename As String
Dim iFileNo As Integer

Open "C:\Test.txt" For Input As #iFileNo

Do While Not EOF(iFileNo)
        Input #iFileNo, sFileText
        strPictureFilename = sFileText

         SQL = "Insert Into TEST EMPLOYEE Values '" & strPictureFilename & "'"

        DoCmd.RunSQL SQL
Loop

  Close #iFileNo


Pramod Chandra

Can you post some sample data from the text file, and the table structure from the table? This is a pretty easy process. I use Scripting.FileSystemObjects, however.

It also looks like you are having issues with the EMPLOYEE field being the PK field and duplicate values trying to be inserted. Is that that problem?

Please post more information and I will post some tested code.

mmcdonal

Look it up at: http://wrox.books24x7.com

Your SQL is wrong.

The format of INSERT is
    INSERT INTO <tablename> ( <list of fields> ) VALUES( <list of values > )

The parentheses are *NOT* optional!

So:

SQL = "Insert Into TEST ( EMPLOYEE ) Values ('" & strPictureFilename & "')"

Did this work for you?

mmcdonal

Look it up at: http://wrox.books24x7.com