 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / May 2005Excel to Access
How do I transfer a worksheet from Excel to a new Access database? Keep in mind that I really don't know anything about Access, so I need to know everything from the point of having the finished worksheet on. Do it from ACCESS. Are you doing it manually or do you need it to work from programming?  SignatureKen Snell <MS ACCESS MVP> > How do I transfer a worksheet from Excel to a new Access database? Keep > in > mind that I really don't know anything about Access, so I need to know > everything from the point of having the finished worksheet on. One easy way is to copy the spreadsheet including the header row and data. Paste it to the table screen. It should ask you "does the first row contain field names" and the choose yes. Then go into the database design and rethink you text, number and other database issues. There are other ways. Import the xls. Match the colums of the xls with a table you designe. Copy and Paste Apend the data records. A table in Access is somewhat like a table in Excel. SignatureSelf taught user of Access 97 – 2003 with 7 years of experience with is part of 20 years of overall database experience. I'm still learning. > How do I transfer a worksheet from Excel to a new Access database? Keep in > mind that I really don't know anything about Access, so I need to know > everything from the point of having the finished worksheet on. In Tables select New/Import changing file type to Excel browse to the Excel file then OK it. Bruce > How do I transfer a worksheet from Excel to a new Access database? Keep in > mind that I really don't know anything about Access, so I need to know > everything from the point of having the finished worksheet on. Thanks to all of you for your assistance. > How do I transfer a worksheet from Excel to a new Access database? Keep in > mind that I really don't know anything about Access, so I need to know > everything from the point of having the finished worksheet on. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.