import excel in access 2000

  • Thread starter Thread starter _Bigred
  • Start date Start date
B

_Bigred

Hello All,

I'm using Access 2000

I am trying to import some data from a excel sheet, it is batting averages
..285 etc.... However when I import my excel sheet into my db, everything
imports except the following fields (they would have a number similar to
above):
Batting avg (BA), On Base% (OBP), Slugging% (SLG), OPS%.

What properties should I have set on these fields in my table?

TIA,
_Bigred
 
Bigred,

That's most likely because those are calculations rather than just typed
in numerical data, and Access doesn't handle Excel functions very well
at importing. Try saving them as values in the Excel sheet (Copy > Paste
Special > Values), and then repeat the import.

HTH,
Nikos
 
Be sure your Access data types are numeric and that the cells in your Excel
sheet are formatted as numeric. They should have the same precision. It is
worthy to note that Excel cells that are formatted "General" and have not
data or have formuals don't work well. If a general format cell has no data
in it, Access sees it as a Null. I am not sure how it sees a formula, but I
regularly import Excel data that is full of formulas, and the resultant
values is what I get in Access.
 
Back
Top