Max

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

Answers (2)