Importing Excel to Table (1 Viewer)

Bsando

New member
Local time
Tomorrow, 02:16
Joined
Aug 5, 2008
Messages
1
HI All,

It has been a few years since I have used Access or VBA so I need a helping hand.
I want to import an excel spreadsheet to a table in my database. The spreadsheet will never have the same name so I don't think I can use the transferspreadsheet command.

Any help would be appreciated
 
Local time
Today, 10:16
Joined
Mar 4, 2008
Messages
3,856
Well you either need to use TransferSpreadsheet, open the Excel as a recordset, or manually import the spreadsheet. All methods require knowing the workbooks file name and location. Since that is true, I'd still suggest that TransferSpreadsheet is the preferred method.

Is it in the same location everytime? If so, use the VB Dir() function to find its name.

Does it have the same structure every time? Will the process be "attended"? Then have the user select the filename from a dialog.
 

Users who are viewing this thread

Top Bottom