I am very new ot using SQL tables. I have created a "form" using excel that people fill out. Some of the cells calculate a percent. The cells are set to "Percent" for the data type with 2 decimal places. However, I can not figure out how to get SQL to recognize the percent. I am using Access to manage/review the data that comes in from the forms people compelte. Essentially, I nned to get SQL to see the value from an excel as a Percent and then display that value in Access.
1) what data tpye should I set the SQL table column to be?
2) What should I have the excel data type be?
3) Do I need to do anything in Access?
Thank you for any advice!!