VB.net Using Linked .csv files as tables

Hi

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.OpenCurrentDatabase("C:\Users\murbro\Documents\Database1.accdb")
        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", _
    FileName:="C:\Users\murbro\Documents\Orders.txt", HasFieldNames:=True)
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
mbizupCommented:
I would simply directly import them.

However with a linked file, you can
- open Access
- Copy the linked table/file
- Paste it
- Select the option to make a local table when you paste it
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
thanks very much
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.

Advertise Here