I am using the following code to link .csv files into an Access database.
I need to convert these to Access tables. How would I do this?
The reason I used this approach would be to side step an import specification
Should I just be doing an import as a table
Dim appAccess As New Microsoft.Office.Interop.Access.Application
appAccess.Visible = True
'Link to a csv file so that it acts as a table in Access
appAccess.DoCmd.TransferText(TransferType:=Microsoft.Office.Interop.Access.AcTextTransferType.acLinkDelim, TableName:="Orders", _