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
|
|||
|
|||
Importing data from excel spreadsheet
These questions are regarding general situations for consolidating data into
an Access database. Some data is contained in a database that has been created (or is in the process of being created) and other data was previously recorded in an Excel spreadsheet. I am trying to consolidate by importing the data from the Excel spreadsheet into the database. First of all, I should be able to import it into the current Access table(s), correct? Since Access data is normalized into different tables and data in Excel are not, would I import appropriate columns into each individual Access table? Would I have to make the Excel spreadsheet have the same columns and be in the same order as the table(s) in Access? Or can I just import it as is on Excel and Access can figure it out? Also, the Excel spreadsheet does not contain all the information that was captured on the later version of Access. Secondly, are there extra steps/precautions to take when importing data from an Excel spreadsheet into an Access database designed with autonumbers? The Excel spreadsheet does not contain an autonumber. However, an autonumber will be required when this information is imported into Access. Do I have Access select the primary key in the table so that it can recognize this imported data or would I have to run a query afterwards to assign an autonumber? Any help would be greatly appreciated. |
Thread Tools | |
Display Modes | |
|
|