Excel Add-in Build Access Import Specification interface
Posted on 2013-12-05
I have an Excel ad-in that handles a large amount of incoming text files into
Access, The following code works fine most of the time, but there are instances where the user needs to actually build an import specification as you would in Access.
Is there something that exists in VB.net already? I realise that that is unlikely so I am looking for a little guidance either on building my own. Alternatively, is there a way to manually pull the file into Excel and somehow use this?
appAccess.Visible = True
appAccess.DoCmd.TransferText(TransferType:=Microsoft.Office.Interop.Access.AcTextTransferType.acImportDelim, TableName:=oTableName, _