Search results

I am using the following VBA to automatically import csv files into an access table: Function ImportCSV() Dim InputDir, ImportFile As String, tblName As String, FinalName As String, specName As String Dim InputMsg As String InputDir = "c:\testFiles\" ImportFile = Dir(InputDir & "\*.csv") Do...

Hi, I'm relatively new to access and am trying to set-up an automatic way of importing the data within excel files, into an access table. For example, the excel files are in the following format: Name,Age,Address,Occupation We have hundreds of these files generated each day, therefore, I'd...