How to connect my SQL database to my workflow

[CDIns]

Currently, I extract whatever tables from my database I need into an excel file and then upload those into my workflow via the input data tool. I have found that I can use the input data tool to pull in query results from my Access database, however, I cant seem to figure out how to just pull in a table. Id have to create a query and then bring that in. Is there any way to link to the table directly without having to create a query first? 

thank you, 

[apathetichell]

select * from {{tablename}} - will bring in everything from your table. that is linking to your table. you must create a query to use a DB datasource.

[CDIns]

thanks, @apathetichell . You've been very helpful on my other posts too. 

Please see attached screenshot, I am still receiving an error message after updating my SQL query. dbo_SMF is the table name in my access database. Am I still doing something wrong? 

thanks, again! 

[apathetichell · Accepted solution]

ignore the {{ }} - that was just meant to say - your tablename goes here.