troubleshooting Question

How To: Displaying Percents in SQL Table

Avatar of bclivell
bclivellFlag for United States of America asked on
Microsoft AccessMicrosoft ExcelMicrosoft SQL Server 2005
4 Comments1 Solution2057 ViewsLast Modified:
Hi All-

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?
4) ect...

Thank you for any advice!!
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros