Access File Import locations

  • Thread starter Thread starter Default for importing Excel files
  • Start date Start date
D

Default for importing Excel files

How do I change the default location for Access to import Excel Files? It
goes to Documents, and we NEVER use a file location on a machine other than
our SERVER. I need all pointers to go to SERVER file locations
 
Hi,
if you are using the windows api for the common open save dialog, there is
an option to set the default directory to open at.

Jeanette Cunningham

"Default for importing Excel files" <Default for importing Excel
(e-mail address removed)> wrote in message
news:[email protected]...
 
Hi,

Do you using a common dialog box, and want to control the file open dialog
startup folder, or do you want ot change the default database folder?
With the common dialog box - you can set the initial folder property and
file spec before you execute the open. For an authoritative overview of the
Common Dialog Box Library here's the msdn link
http://msdn2.microsoft.com/en-us/library/ms645524(VS.85).aspx

For the default database folder, it depends on version - like a lot of stuff
does.

Assuming Access 2003 You can change the default database folder by going to
Tools, Options, click on the General Tab, down near the bottom left there is
a textbox where you can change the default database folder. Access 2007
click on the circle button extreme upper left corner (I still don't know the
right name for that button) , bottom of the menu is a button named Access
Options. That's where you will find the default database folder.

NOTE/CAVEAT: This may create various other issues - if you open Access to
start a new database that will be the default folder Access will attempt to
save the new database in, and when you open Access directly, that is where
it will start looking for your applications.

Hope this helps,
Gordon
"Default for importing Excel files" <Default for importing Excel
(e-mail address removed)> wrote in message
news:[email protected]...
 
Changing the Default Database folder does not seem to change the start in
directory when choosing a file to import. It always points to My documents. I
want to change this to point to someotherfolder.

Anyone else overcome this ?
 
Hi,
If you are using the import wizard, there isn't any way to change the
default directory to import from.

Jeanette Cunningham
 
Back
Top