0

I'm running a database on AWS Lightsail and I have a bunch of .txt files I want to import into the database. I can't merge the files because I want to create one table per text file (table name = txt file name).

Is there a quick way to do this other than using the import wizard and importing one-by-one?

Here's the format of the text files (id:firstname:lastname)

textfile1.txt

10000:john:smith
10001:alice:wonder
10002:mark:asdf

textfile2.txt

9878665:joe:cheerio
9878666:player:one
9878667:yolo:swag

So ideally it would create a table called textfile1, and textfile2, and so forth. All these txt files are just in a single folder.

How can I automate this?

1

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.