Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Creating an Import Browse Window

Status
Not open for further replies.
Gonzo18

Gonzo18

MIS
Jul 15, 2002
3
US

Registered: Jul 2002

online
07-17-2002 06:04 PM

--------------------------------------------------------------------------------

Import Browse Window
I have a certain excel spreadsheet which I would like my users to download. The only catch is that the location of this spreadsheet is variable, and I would like to have the users browse for it.

I do not want them going into import manually, and I would like to have the table permanently named no matter the name of the spreadshet. The first row DOES contain the column names, and there are no keys.

Is there a vba way to do this?

Greg
 
Status
Not open for further replies.

Similar threads

BugZap13
  • Locked
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
588
mikrom
mikrom
JK Dutta
  • Locked
  • Question
requet for form an access query for report
Replies
2
Views
4K
dhookom
dhookom
C
  • Question
Run-time error '3075': Syntax error (missing operator) in query expression 'Birthday = and Birthmonth ='.
Replies
3
Views
287
OzFoxy
OzFoxy
datajockey123
  • Locked
  • Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
781
dhookom
dhookom
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
4K
lameid
lameid

Part and Inventory Search

Sponsor

Back
Top