change default path to external data?

[HiTekRedNek]

Hi,

I was wondering if there was a way to change the default path when you are in "Get External Data" - "Specify the source of the data". The default is My Documents but I would like to change the path to open in my commonly used folder.

 

[ghudson]

Are you trying to automate an import file process?

 

[HiTekRedNek]

Are you trying to automate an import file process?

Yes, but the external data I am trying to import is an excel file of data that I manually extract from our monitoring application each week. In that regard I think I am limited on fully automating the import process so I am trying to at least have the default always open up to a folder of my choice.

 

[vbaInet]

You would need to create your own Import routine.

Something like this might help:

Public Function ImportTable(myFile As String)
    DoCmd.TransferDatabase acImport, , "Full_Path_To_Folder\" & myFile, acTable, "Importing_From_Table", "Importing_ToTable", No
End Function

That would go in a module.

 

[HiTekRedNek]

You would need to create your own Import routine.

Something like this might help:

Public Function ImportTable(myFile As String)
    DoCmd.TransferDatabase acImport, , "Full_Path_To_Folder\" & myFile, acTable, "Importing_From_Table", "Importing_ToTable", No
End Function

That would go in a module.

I'm weak with VBA. I think it's time I learned. Now only to find a good book or resource for beginners. I value your suggestions.

 

[SOS]

You might try the 2007 VBA Programmers Reference

or if you want to start off as beginner first - Beginning Access 2007 VBA

or some free tutorials

Access 2007 VBA

Access 2003 VBA

 

[greymont]

Is there really no way to permanently change this default? I'm shocked.

I'm not trying to automate an import programatically. I do many manual imports and I just want to shorten the time it takes to browse to the input file.

Any registry entry that can be changed?

 

[vbaInet]

If there was a way then it would be under the Access Options.

You can use the File Dialog control and set it's default path. Whatever is returned from that control would be the path you use for the import.

 

[greymont]

You can use the File Dialog control and set it's default path. Whatever is returned from that control would be the path you use for the import.

I didn't follow that at all. Is that a setting or what?

I'm not doing any programming here. Just using the product as it came.

 

[vbaInet]

You would need to do some programming to achieve what was explained and this would entail "bypassing" the built-in import routine.

Search the forum for File Dialog and TransferText method. There should be some threads related to these topics.

 

[ghudson]

You need to design a custom browser into your database. Check out my old Browse [Find a directory or file] sample to see how easy it is to do and use.

 

[greymont]

Ok. Thanks for the help.

 

[wiglet]

I am incredulous that something so basic is not under the control of the user. Why not provide this under the 'Access Options' feature. Baffling.