The easiest way
1. Prepare an ODBC datasource for your SQL server.
2. Open MS Access (big assumption, I know)
3. Go to File->Get External Data->Import
4. Select Text Files (another assumption) from the Files of Type Box (Choose alternate file type if needed)
5. Follow the wizard to describe...