TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Max
NA
5
0
Import Excel file to Access DB on remote server
Sep 19 2007 2:00 AM
hi guys,
the organisation that I work for has a website using an access db (mdb file) hosted on a server running .net 1.1 and asp.net. currently the web site is able to list a number of members of the organisation that it pulls out of a 'members' table in the access db. the current web site is able to export all the members info to a csv file and is also able to add and edit individual members. I've been asked to create functionality to import an entire excel spreadsheet into the members table. at present I'm using visual studio 2005 to do all my coding so what I thought I might do to add this functionality is to create a windows forms project to import the excel spreadsheet into the database (as the hosting platform doesn't support .net 2.0). is there some way of interfacing my app with the access db on the server? I've also thought of grabbing a copy of VS 2003 to create .net 1.1 compatible code, but I hear that the RAD data tools in VS 2003 aren't as good as those in VS 2005, so this is not a preferable option...
thanks in advance,
max
Reply
Answers (
2
)
Exception: Object reference not set to an instance of an object
DataSet one-to-one link relation of tables