asked on

File open Prompt Using in VBA

I want to import a spreadsheet into a microsoft access table. I need a typical windows file open prompt to appear so the user can choose the file they wish to import and once selected inport the spreadsheet into a table

Can anyone help me with this?

rockiroads

https://www.experts-exchange.com/questions/21865838/How-to-capture-Word-document-name-to-store-in-Access-table.html

rockiroads

pick the 2nd one

puppydogbuddy

Download free demo and source code "Browse and Open Files" at this link:

http://www.candace-tripp.com/pages/access_downloads.aspx#8

jefftwilley

I've been assisting another with your same intentl...might be helpful
https://www.experts-exchange.com/questions/21882261/Import-Excel-spreadsheets-into-existing-MS-Access-database.html#16895169
J

oogooglies

ASKER

rockiroads, thanks that is exactly what i needed. The next step is to use the file selected and import it into a table within the access database... how would i go about doing that?

jefftwilley

Check the link I pasted...that's exactly what I'm helping him do.
J

ASKER CERTIFIED SOLUTION

rockiroads

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

oogooglies

ASKER

Thanks for your help, i have just got there before refreshing... slightly differently but basically the same....

oogooglies

ASKER

Thanks jefftwilley, but rockiroads solution fits the bill perfectly. Cheers for your help

oogooglies

ASKER

rockiroads,

Can a similar dialogbox be used to save data selected from a query into a file..... Again so i acts and feels like windows?

Thanks

Anthony