Search results

I'm able to answer my own question! Here's the difference from above: (1) Specify the properties Connect and SourceTableName AFTER creating the TableDef; (2) DO NOT specify any fields -- these will be defined into the TableDef Object when the the source file name is opened, with the guidance of...

Anyone can readily establish a linked table to a flat (e.g., .txt) file manually. The end result is a table that shows in Access marked with a sort of Notepad icon and an arrow showing it's for input. I've experimented a lot with code similar to the one I show below. In this forum, I've read...

I'm making a living now as a software developer in VBA, of the Microsoft Office suite. I joined this forum because I can't land a solution creating a Microsoft Access linked table to a flat file using VBA. In other words, I can't replicate what I straightforwardly do manually. I guess I'll make...