Importing dialog box

  • Thread starter Thread starter dp724 via AccessMonster.com
  • Start date Start date
D

dp724 via AccessMonster.com

At the click of a button my code begins importing my Excel data in to an
Access table; but the dialog box which appears so the file to be imported can
be selected is not sorted, so I have to change the 'view' to 'details' so I
can sort the files to easily find the file to import.

I'm using Ken Snell's method described here:
http://www.accessmonster.com/Uwe/Forum.aspx/access-macros/6431/Import-from-Excell-Macro


to import my Excel file.

Can someone please help by providing some instruction or preferably some code
I can plug in to my code, so the box appears in details view sorted A-Z.

Thanks in advance.

Dave
 
You can link to the Excel files rather than importing them.
Then use a append query to copy the data into a table you have already
prepared.
Set the indexing on the table the way you want it.
 
Thanks for suggestion, creating the links was considered, but importing the
data is the ideal set up.

If you're familiar with the open file dialog box which pops up during the
import process and have any ideas on how to easily force it to open in
'details' view, sorted A-Z, me and countless others would be greatly indebted
to you.

Mr. Steele suggested referencing the following:
http://vbnet.mvps.org/index.html?code/hooks/fileopensavedlghooklvview.htm

...but expert knowledge is required.
 
I am currently doing the same thing daily. I import the file, then I run an
append query to copy it into my table. The appended data is sorted according
to the destination table's format.
 
Back
Top