|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 11th, 2009, 05:38 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
35 fields
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  
|
|
#2
August 11th, 2009, 06:38 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
35 fields
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" wrote in message news  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
|
|
#3
August 11th, 2009, 11:00 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
35 fields
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" wrote: 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" wrote in message news 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
|
|
#4
August 11th, 2009, 11:06 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
35 fields
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" wrote in message ... 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" wrote: 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" wrote in message news 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
|
|
#5
August 11th, 2009, 11:15 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
35 fields
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" wrote: 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" wrote in message ... 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" wrote: 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" wrote in message news
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
|
|
#6
August 12th, 2009, 12:18 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
35 fields
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 "Heather" wrote in message ... 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" wrote: 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" wrote in message ... 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" wrote: 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" wrote in message news
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
