Skip fields on import into existing table

[cybrooksy]

Guys,

I've one text file, which I want to import into three different tables - skipping fields which are in the text file but not the designated table. You could do this in Access 2003 - but Access 2007 does not, you just get a 'subscript out of bounds' error.

Is there a way around this? Am I mistaken about being able to do this before?

Access help suggests that I amend the original text file - which I can obviously do but would rather not go through the hassle of this.

Any thoughts?

SJB

 

[boblarson]

Guys,

I've one text file, which I want to import into three different tables - skipping fields which are in the text file but not the designated table. You could do this in Access 2003 - but Access 2007 does not, you just get a 'subscript out of bounds' error.

Is there a way around this? Am I mistaken about being able to do this before?

Access help suggests that I amend the original text file - which I can obviously do but would rather not go through the hassle of this.

Any thoughts?

SJB

I would just bring the file into a "transitional" table where you import everything in (using a delete query to clear it out before importing each time) and then use append queries to send the data where you want it to be.

 

[boblarson]

Oh and

 

[cybrooksy]

Thanks Bob! That's a great idea.

Simon