I am trying to import a TEXT file into ACCESS using a macro (using import delimited). But what happens is that it creates a table with only one field and also generates an error table which seems to state that Row 2 is "unparseable"

Now when I import the same TEXT file using File->Get External Data-> Import (and then choosing a file to import), it does it without any problem. Would appreciate an insight and solution to this problem. Thanks.

You need to set up a specification name.

look at your macro click in this field and press F1 to read the help on this, pay particular attention to the "advanced" part.

Ziggy

Thanks. That really helped.:)