How does one relink a linked txt table.
All fields end up concatenated in the first one with the general method
using RelinkMoethod

I understand a schema.ini file is needed. I cannot find any
documentation on this what so ever, how does one actually relink with
code.

Thanks in advance. ,

I'm pleading with the gods.

I'm not a high-tech in this matter, but will try to help.

Try to get the "connect" property to view how it is built. Then change it
and use Refreshlink method.

click File\GetExternalData\link tables
under files of type, select 'text files'
under filename select your test file
click Link
when the link text wizard comes up click on the 'advanced' button
click the 'save as' button and enter the name you want for the link
specification
click ok, and finish specifying the link specification

on the 'macros' tab, click 'new'.
under action choose 'TransferText'
choose your link spec from the 'Specification name' combo box
set values for transfer type, table name, and file name.
run the macro to make sure it does what you want.

in the macros window rightclick on the new macro and
select 'save as\export'
select 'save as visual basic module'

delete the link and add it back with updated connection info