Items in a standards compliant Atom feed have a defined structure. Therefore the schema is expected to be as the standard defines. Use the hard coded value of "AtomFeed" as table name when querying, i e SELECT * FROM AtomFeed
This connection string (Atom Feed using RSS Data Provider) can be used for connections to
RSS / Atom.
Start over in the connection string reference index.
You can also get help in the Q&A forums where you can ask your own question.
The kb articles contains how-tos and instructions and you can search for anything if you're not sure were to look.