• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 360
  • Last Modified:

Excel Text to Number Formatting

Hello again,

I am running into problems with numeric data when I import it into MS Access, and export back to Excel. It converts the numeric data to text. I found solutions for this on the internet but the only one that seems to work is to go to the Error Checking button and manually tab through every field in the spreadsheet until all are converted. There has to be a better way. Using the standard method of formatting does not work for this. I have to perform calculations on this data  and the spreadsheet is going to get very large and this method will be time consuming and tedious. Can someone assist?

Thanks, Janis
0
DMKetcher
Asked:
DMKetcher
  • 5
  • 3
1 Solution
 
Martin LissOlder than dirtCommented:
What is the format of the field in Access that receives the data?
0
 
DMKetcherAuthor Commented:
I am importing excel spreadsheet data into an empty unformatted table. It converts when it imports. Does that help?
0
 
Martin LissOlder than dirtCommented:
Do you have to do it that way? I've never done what you're doing but I assume that if the field in Access were numeric that you wouldn't have a problem.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
DMKetcherAuthor Commented:
It is the only way I know of to import data from Excel. Is there a better way? I always got to MS Access, External Data, Import & Link, Excel - and then use the wizard to bring in the file and it saves as a table. Normally the data saves as the same data type. I am working with currency in excel so that could be part of the problem.
0
 
Martin LissOlder than dirtCommented:
In Access create a table that contains a Currency field and then use the Access wizard to import into that table.
0
 
DMKetcherAuthor Commented:
OK I will try it and get back to you. My workbook data originations in Excel and contains numerous numeric fields. I don't want to have to figure out the layout from the point of view of access without a template. Is there an easy way to use an Excel template and then format each field in Access?
0
 
DMKetcherAuthor Commented:
I did not have unique field names. That was the problem. This is closed. Thanks for all of the comments.
0
 
DMKetcherAuthor Commented:
It was the true answer. I figured it out.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now