Link to home
Start Free TrialLog in
Avatar of pgmerLA
pgmerLA

asked on

How to create a simple SQL table from a txt file

I am a beginner programmer.
I need to create an sql table from a text file.
I need to have 6 columns and since the file is large, I don't know how many rows I need.

I need a very step by step tutorial.
Avatar of tigin44
tigin44
Flag of Türkiye image

do your text file has any structure on the rows... if so you can use the import/export wizard to create your table. By the way you dont need to know the row number of your table. you should be care just the columns and their data types. I f you can provide a sample data we may guide you more
Avatar of pgmerLA
pgmerLA

ASKER

Here is a sample of a txt file I need to create an sql table for.
OCENY.txt
ASKER CERTIFIED SOLUTION
Avatar of Ephraim Wangoya
Ephraim Wangoya
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial