Hi, I am not sure I understand the question.
However, you can import an Excel spreadsheet using File, Get External data and pick a file type of Excel. The rules for importing are the following: The sheet name will be the table name. You can import into an existing table. The first row MUST have the field names the way they are in the table, if the table exists. If the table does not exist, Access will create the table with field names for you. All fields will be imported. You can put additional sheets and import them into other tables. Hope this helps, Kind regards Peter -- Peter T. Fairchild Consultant en Informatique [EMAIL PROTECTED] +41-(0)79-715-9155 Portable +41-(0)21-800-4044 Office "Form and Function are one" Frank Lloyd Wright 1867 - 1959 mshafeela wrote: > Hi all, > > I have spread sheet like data with 400 rows of data .This has 10 > columns . Now this sheet is going to be repeated for 6 stages of work. > > How should i design if > 1. I need to input single letter entry to this 400 x 10 x 6 cells. > 2. According to the specific stage the data in the description column > will also change. > > Please help urgently. > > > > > Yahoo! Groups Links > > > > > [Non-text portions of this message have been removed]
