Having trouble opening an access file using this code.

**djbummy** · 02-09-2009, 04:17 AM

Using the following code

Please Login or Register  to view this content.

displays dialog box but the files i double click on do not open?

thank you

**Bob Phillips** · 02-09-2009, 05:47 AM

GetOpenFilename does not open the file, it just returns the full path of the selected file(s). You have to manually open the file in your code.

**ravishankar** · 02-09-2009, 06:32 AM

Hi
Are you running these codes from excel or access? Do you intend to import data from access to excel? try adding this code after getopenfilename

Please Login or Register  to view this content.

Ravi

**djbummy** · 02-09-2009, 12:37 PM

Thank you for the replies

After further investigation for what i wanted to do. I have found it much easier to use the Import spreadsheet procedure from the access database. This has solved my problem.
Thks

FYI

For anyone concerned

If you want to import to an existing table in ms access, make sure you have included the field names exactly as they are in your access table into the first row of your spreasheet. Also the formatting must match your access fields ae: Date and Time fields.