Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Importing from Excel to Access DB

Comment:

i'm trying to figure out the code to add an import-from-excel option that will place data in its correct fields as seen in the following pic of the access db i am using: http://i10.tinypic.com/52nz98n.jpg (i.e. name into the name fields, etc etc) i added the circled button but don't know the code that will make it work as intended. any help is appreciated, thanks

Name: Jennifer SUMN
Date: August 1, 2007 at 07:04:33 Pacific

Reply:

Have you considered just linking to the Excel spreadsheet, or do you definitely want to import the data? If linking isn't an option, here's a third-party add-in designed to do what you want: http://www.4tops.com/download.htm Life is more painless for those who are brainless.

0

convert access to mySql

Access 2003 field extract...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: You can import an Excel file into Access. Right click on the white-space in the first window you get and select 'import' this should allow you to chose an Excel sheet. ...

Summary: I am having trouble importing excel spreadsheets into Access 2000. When I select the file to import there is a message in the status bar saying "Import Spreadsheet Wizard" but the wizard is not visibl...

Summary: Are you able to use any tools like Perl that could read this as a datasource and import to access rather than doing an export to something that won't maintain extended information? ...