Search results

Hi everyone, I am building a select query which is grabbing data from multiple tables with items being linked by a unique field "Certificate_ID". I have created joins between table A and Table B, and Table A and Table C, linking both by Certificate_ID All have the join property set to...

Hi all, I have a module for importing several excel files from a folder in Access. The user is prompted to select the folder which contains the Excel files. The issue: The code works fine if I select a folder from my company network drive (strFile variable returns with correct file name)...

Hi everyone, I have a database which is importing several Excel workbooks, each with multiple worksheets. Every workbook has 20 worksheets, with the same 20 worksheet names. When they are imported they come in as one table for each worksheet, named tblWorkSheetName_X with X starting at 1 and...

Hi all, I am very new to using VBA so could really use some basic help! I have a set of Excel files with several worksheets in each. These worksheet names are common across the files and all of the files are located in one folder. I want to import all of these files into Access as separate...