https://community.developer.cybersource.com/t5/Integration-and-Testing/Import-a-txt-file-to-my-database/m-p/76024#M47466 <P class="_1qeIAgB0cPwnLhDF9XSiJM">I have a txt file which gets issued periodically. It's tab separated and I'd like to automate getting that data into my database as efficiently as possible. I'm new to MySql but experience says that I'm not going to be the first to have this issue.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">I feel like I should be able to import a table using code (not a workbench), but I can't find that solution. Is updating 40k lines one by one my only solution?</P> Wed, 28 Apr 2021 12:52:07 GMT BronxCruz 2021-04-28T12:52:07Z https://community.developer.cybersource.com/t5/Integration-and-Testing/Import-a-txt-file-to-my-database/m-p/76024#M47466 <P class="_1qeIAgB0cPwnLhDF9XSiJM">I have a txt file which gets issued periodically. It's tab separated and I'd like to automate getting that data into my database as efficiently as possible. I'm new to MySql but experience says that I'm not going to be the first to have this issue.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">I feel like I should be able to import a table using code (not a workbench), but I can't find that solution. Is updating 40k lines one by one my only solution?</P> Wed, 28 Apr 2021 12:52:07 GMT https://community.developer.cybersource.com/t5/Integration-and-Testing/Import-a-txt-file-to-my-database/m-p/76024#M47466 BronxCruz 2021-04-28T12:52:07Z