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
|
|||
|
|||
Simplified table creation
I have an Excel file with a long list of variable names I want to use to
create a table in Access. Is there somewhere I can paste them into the table design all at once so I don't have to type or paste them in individually? |
#2
|
|||
|
|||
Simplified table creation
You could open an Access file and "point" to the Excel file.
If the list is unlikely to change, and if you'd rather keep it in Access than in Excel, you can "import" the data. If the list may change and you need to keep it in Excel, you can "link" to the Excel data. Regards Jeff Boyce Microsoft Office/Access MVP "MaryJC" wrote in message ... I have an Excel file with a long list of variable names I want to use to create a table in Access. Is there somewhere I can paste them into the table design all at once so I don't have to type or paste them in individually? |
#3
|
|||
|
|||
Simplified table creation
On Wed, 8 Jul 2009 14:49:02 -0700, MaryJC
wrote: I have an Excel file with a long list of variable names I want to use to create a table in Access. Is there somewhere I can paste them into the table design all at once so I don't have to type or paste them in individually? You can open Access and use File... Get External Data... and either Import or Link to the spreadsheet. Choose Excel from the "files of type" dropdown. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|