Import file in current folter

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

I'm using the TransferSpreadSheet function to importdata
from an excel spread. The *.xls file is in the same
folder as the database. I would like for the program to
look in this folder (current folder) for the file rather
than the default data folder. When I type in the filename
is there a way to indicate the current folder without
typing it in.

The name of the current folder will be different on
different computers.

Thanks...
 
You can use the CurrentProject.Path in the code to be the current path.

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, _
"TableName",CurrentProject.Name & InputBox("Enter the filename.")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing Data Error Checking 1
Import 4 Different Excel Files from One Folder 0
Excel Import External Data by Date Automatically 0
Import Several excel files into Several Access Tables 6
Command Line to Open/Close an Excel Files , macro print it in a designated Folder 1
How can I migrate MBOX to PST? 2
Importing Excel spreadsheets from a folder 5
Export from Access 2007 to Multiple Worksheets in Excel 6

Back
Top