Simplified table creation

  • Thread starter Thread starter MaryJC
  • Start date Start date
M

MaryJC

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 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
 
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?
Click to expand...

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.
 
Back
Top