I have written a procedure that imports a text file and enters each line into a table on a MS SQL Server Database.
The table is linked to my access database.
I have imported the file, and it runs without error. But when I open up the table in Access it shows 54 lines with each column containing the "#Deleted". When I open up the table on the SQL server all 54 lines are populated with the correct text.
Can anyone explain why the data appears fine on the SQL server but will not display in Access
Code:
10 On Error GoTo err_ReadInFile
Dim strTextLine As String
20 Dim intFile As Integer: intFile = FreeFile
Dim db As Database
Dim rs As Recordset
30 Set db = CurrentDb
40 Set rs = db.OpenRecordset(strTable)
50 Open strFilename For Input As #intFile
60 Do Until EOF(1)
70 Line Input #1, strTextLine
80 Debug.Print strTextLine
90 With rs
100 .AddNew
110 !IF_TextLine = strTextLine
120 !IF_Category = strCategory
130 .Update
140 End With
150 Loop
160 Close #intFile
170 rs.Close
180 Set rs = Nothing
190 Set db = Nothing
The table is linked to my access database.
I have imported the file, and it runs without error. But when I open up the table in Access it shows 54 lines with each column containing the "#Deleted". When I open up the table on the SQL server all 54 lines are populated with the correct text.
Can anyone explain why the data appears fine on the SQL server but will not display in Access