A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Simplified table creation



 
 
Thread Tools Display Modes
  #1  
Old July 8th, 2009, 10:49 PM posted to microsoft.public.access
MaryJC
external usenet poster
 
Posts: 2
Default 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  
Old July 8th, 2009, 10:58 PM posted to microsoft.public.access
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default 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  
Old July 8th, 2009, 11:57 PM posted to microsoft.public.access
John W. Vinson
external usenet poster
 
Posts: 18,261
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:30 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.