Problems in importing a TEXT file into ACCESS using a macro

[AshikHusein]

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.

 

[Ziggy1]

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

 

[AshikHusein]

That worked. Thanks!

Thanks. That really helped.