Importing CSV file into 2010/creating save import routine

[rbtrout]

I'm not sure whether this should be 2 separate posts, but since it's a similar problem -
I created a program in 2003. It has a saved import routine that imports a CSV file from C:\program files\exports\data.csv. No problems.



In 2010, that function stopped working as Access said that the import routine 1 didn't exist. I recreated it in 2010.

First of 2 problems -
The import routine doesn't import the data as entered, which makes it very difficult to proof.

Second of 2 problems -
I thought that deleting the saved import specs and re-creating them with a different name might solve the problem. No go. When I go to the import step in the macro and try to select the newly named/saved routine, it doesn't appear in the list. No matter what I've done (even compact/repair), no luck.

I'm stumped at this point and could sure use the help.

[rbtrout]

Guess I'm SOL.

[rpeare]

The problem may be that you're using an import spec name or export spec name in 2010. To my knowledge (with 2007) you can not use specification names in your VB code within access anymore. Why they removed that functionality is beyond me. You are more likely going to be required to save the import steps and call that process rather than using the name of the import spec.

[rbtrout]

I am using a spec name. I'll check into this and see what happens. Thanks for the help.

[rpeare]

DoCmd.TransferText acImport("Your Import Saved Process Name Here")

[rbtrout]

That was it. Thanks again for the help!