Kevin,
Thanks alot. Unfortunately, it tells me that the "File is already Open" and exits without even processing the SQL. I'll continue to research it and see if I can come up with something.
Thanks for all your efforts, I appreciate it.

Tim

Tim,
Does your form, in the on_open process, use the opentextfile commmand?
If it does, turn it off, then try again.

Kevin

Kevin,
I'm not at work today but here is the situation: I get the error message "File is already open" when I run the code the second time. The form doesn't automatically open the document and I can't see it either, although it is "open".
Also, the SQL statement cannot understand the field "text line". I don't have the database here with me but I think your code is close to doing the trick. If I can solve the SQL part, it should work fine.
Thanks for all your help

Tim

Tim,
Do you have a column in your table called text line? In my sample code, the table name is "Text Table", the Column is "Text Line". You need to rename these to match your table and column. Your variable to load each line is "textline".

Try that and let me know.

Kevin

Kevin,
I am getting a "syntax error in INSERT STATEMENT".
Here is the actual VBA that I am using:
Dim TextLine
Dim strquote As String
strquote = """"

Open "M:\3780\CorpActions\corp_pfd_namr.cax.2005013 1" For Input As #1
DoCmd.SetWarnings False
Do While Not EOF(1)
    Line Input #1, TextLine
    SQL = "INSERT INTO [tbl_corp_pfd_namr] ([CPN_Field1])," _
        & " SELECT " & strquote & TextLine & strquote & _
        " As Expr1:"
        Do.Cmd.RunSql SQL
Loop
Close #1


The SQL statement reads the "SELECT" part as SELECT Start-of-File....

Tim

Tim,
The last statement of your sql - "As Expr1:' is wrong.
It should be - " As Expr1;"

Hope it works, let me know.

Kevin

Tim,
There should also be no comma after ([CPN_Field1)" .
Cut and paste this in:

SQL = "INSERT INTO [tbl_corp_pfd_namr] ([CPN_Field1])" _
        & " SELECT " & strquote & TextLine & strquote & _
        " As Expr1;"
        Do.Cmd.RunSql SQL


Let me know!

Kevin

Hi Kevin,
I get the message "Enter Paramter Value"
                   START

Could be getting there!

Kevin,
I'm getting the code to work now (I had changed the strquote earlier but changed it back to your specification). However, there are three outstanding issues:
1. I get this message when Access encounters the first row with more than 4 columns:
    Syntax error (missing operator) in query expression "264399BB1 corp100481117...the rest of the problem record
The first row is only 4 columns which sets the trend for the import.
2.When I click "O.K", I get a myriad of messages that say "Type Mismatch"
3. It still tells me that "The File is already Open" when I try to do it a second time!
Thanks again for all your input and expertise
Tim

I also for got to say that it imports the four columns to the first field only. I will try to insert other fields to the SQL statement.
Tim