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!

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

I want to use an excel file for inp

Status
Not open for further replies.

JAB_123

Technical User
May 7, 2023
2
0
0
US
I want to use an excel file for input to showcase query parameters. I know where to browse for the file, How do I specify the sheet? Does it default to sheet2, or the first sheet.
 
Do you want to create a link to an Excel sheet from MS Access? If so, how far did you get?


Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016
 
This was my first time posting. I do not see how to reply to your reply. I am not using access. I am using a showcase query / showcase report writer. You can specify a pc file rather than screen prompt. You select this option from a drop down, and then browse for the file. You specify a column number, but I cannot find how to specify the sheet,
 
You did reply to my post. I expect you should search for “Showcase report writer support forum”.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top