I have created an Access db that has a few macros to automatically delete records, import legacy data, then close itself. Since I can not put MS Office on our live server I am wondering if I can do this in VB code?
so far for the import section I have written:
dim accImport, db, fso
set accImport = CreateObject("Access.Application")
set fso = CreateObject("Scripting.FileSystemObject")
set db = fso.GetFile("path to my db")
accImport.DoCmd.TransferText acImportDelim, "Schema.ini", "table1", "path to the file that gets converted", False, ""
Set appAccess = Nothing
What I want to know is if this is possible, since I will be manipulating an Access file on a server that doesn't have MS Office installed on it.