Link a text file to Access using VBA
Does anyone know how to link a text file to an Access
database using VBA code? I've tried variations of
the DoCmd.TransferDatabase using a TransferType of
acLink, but it seems that there is no option under
I have been able to link the text file using File |
Get External Data | Link, but have had no luck at
all trying to do this using VBA.
I know that linking a text file or Excel spreadsheet
may be considered more of an exception in many
respects, but any ideas would be GREATLY appreciated!
Thank you. :)