Exporting in Access 2007

[Guest]

We are upgrading to Access 2007 and can not get our export to work. VBA is
doing the export and the file name has no extension. If an extension is
used, the file will export properly except that the file can not have an
extension for the purpose that it is being created. In older versions there
was a table (I don't know where) that would allow output without the
extension. Does this still exist? Where? Because the exported file is now
automatically loaded to another system it would be difficult (read slow) to
stop the process and rename the file and then continue the process. Any help
is appreciated. Thank You!!!

 

[Guest]

I have since been able to determine that the table that allows export without
extensions is in the registry. Apparently when the Access 2007 was installed
it did not pick up the information from the registry files for previous
versions? Or maybe the 2007 program no longer looks to the registry for such
information and maybe it is now part of the Access 2007 file information?
Thanks for any help as this is a real bottleneck for us.

 

[John Nurick]

Hi,

I don't yet have Access 2007 here so can't check this for myself. In
case you haven't found it, this http://support.microsoft.com/kb/290068
covers the registry entry for Access 2002 and 2003; I'd check this
entry and also look for a corresponding one relating to Jet 5.

For a work-round, just modify your code so it either

-renames the input file with a suitable extension, using the VBA Name
statement
-imports the data
-restores the original name

or

-makes a copy of the input file with a suitable name
-imports the data
-deletes the copied file.