Using Excel 2003 to Manipulate Access97 table

[officeguru]

Greetings!

I maintain an Access 97 database for a small group of users. When our company upgraded from office97 to office 2003, they didn't get Access 2003, and they removed access97 from most users desktops.

Is there a way to use Excel 2003 as a data-entry tool for Access 97? I know I could extract the data fields into a table-friendly format in excel and then export that to access and append the export to my access tables, but there must be a more elegant solution.

The spreadsheet I am trying to use has some 'header' information, User name, Project, date requested, date due... and a variable number of data lines, with fields like Idnumber, size, description.

I am not looking for someone to write my code, I just need to be pointed in the right direction.

Thanks,
Brian

 

[abaldwin]

Are you looking then to basically replace the forms you had in access?

You can surely write a lot of forms in Excel and using ADO, ODBC etc retrieve and write to an access file you place on the machine. I would think they should simply look at an upgrade to access and smaller modifications to code if required.


Andy Baldwin

"Testing is the most overlooked programming language on the books!

 

[officeguru]

Thanks Andy,
I am not replacing existing forms, I have added some functionality to my database, and other users want to be included. They have been filling in a spreadsheet, printing it and routing the print. I want to capture their data from the spreadsheet, save and report from it. The problem I am having with ADO, ODBC etc is that the VBA coding seems to have changed from 97 to 93 and I can't seem to get the 2003 spreadsheet to talk to the 97 tables. I don't have specific code to comment on, but none of the example code I have found in my reference books or on the web works.