Recent content by petho

Can you please clarify exactly how you mean? I'm very new to VBA... Ta.

FYI - this is my current code: Function ImportCSV() Dim InputDir As String, ImportFile As String, tblName As String, FinalName As String, specName As String Dim InputMsg As String Dim TheDate As Date Dim fs Set fs = CreateObject("Scripting.FileSystemObject") 'set the location of the...

Excuss my lack of VBA knowledge, but when I run the script, an error appears as "Compile Error: Sub or function not defined" which is referring to the substr Do I need to define both TheDate as well as substr and if so, what to? Cheers.

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...