35 fields

[Heather]

Hi, is there a maximum # of fields that we are allowed to import into an
Access table -- I have 35 fields from an excel table that Access is saying
that I have too many fields defined? Thanks

 

[Gina Whipp]

Heather,

That would only be limited by the number of fields in a table, which is 255.
Sounds like a bogus message... how are you attempting to import, ie:
File-Get External Data-Import OR TransferSpreadsheet OR custom module? WHat
are the field names?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Heather]

Hi Gina, somehow it decided to accept this but not it's not letting me insert
a couple of columns for calculations saying too many fields defined and it
does the same if I try to chg a data type from this list as well

Booking Qtr
Year
Global region
Channel Account Region
Channel Acct Type
Deal Id/SO #
Deal Type
Sold-to name
Contract End Date
Renewal Year
Renewal Quarter
Renewal Group
Renewed Y/N
Lost Reason
Debooked
Renewal/debooking Deal/SO#
Renewal Bus Model
Renewal Deal Amt
Renwal Term Mos
Term Mos
MAP Account $
USD FRP
USD Local list price
USD Total Fees
Annual Fees (col Y)
USD Discount %
Access Rate
Comments
Eligibility Status - Chris Potts
Credit/Debook QTR
Credits/Debookings
Annualized Orig Deal
Annualized Renewal Deal
Delta
% Chg

 

[Gina Whipp]

Heather,

Okay, well I am glad you got the data in. As for calaculations, they do not
happen at or in the table so I understand why it won't accept those
columns.. Calulations are done in a Query. Why are you trying to change
the Data Type... Let's start from the beginning, why are you moving this to
Access?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Heather]

We have several very large excel workbooks that have started crashing this
qtr and need to put the data into Access. In several of the columns such as
discount, access rate, annual fees etc they are calculations. So I was hoping
to have the column in there and then do update queries to do the formulas

 

[Gina Whipp]

Heather,

It seems to me you are thinking Access is Excel on steriods. That would be
wrong. Tables are not spreadsheets and do not do calculations or totals or
much of anything that a spreadsheet does except hold data. Trying to use
Access like Excel would be much like trying to teach a pig to dance.

If your Excel spreadsheets have started crashing you might ty upgrading to
Excel 2007 which hold MUCH more data then it's earlier versions until you
have a chance to check out those links I sent you in an earlier posting and
perhaps reviewing the Northwind sample database. If you happy with using an
Access table like a spreadsheet then you can use a good old fashioned Select
Query to do calcualtions which are never stored in the table (well, there
are exceptions but then only the final tally should be stored).

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm