I have a db (Access 97) that needs to do an import daily. I have an import spec set up. When I use the spec to add to an existing table, it crashes Access and does not add any records.

All of the fields in the table are text, so I do not think it's a problem with data type.

When I use Access 2002, it all works fine. Problem is, my company's environment is 97 and this won't change any time soon. I need to automate this so that my machine is not the only one that can do the import.

Any suggestions?