Excel to Access Converter Utility Program

[ryguy7272]

I downloaded this Excel to Access Converter Utility program:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=182

I reviewed the instructions and it seems pretty straightforward. So, I
tried to open the ‘Excel-Access Converter 2003’ file and I get this message.
‘This database is in an unrecognized format. The database may have been
created with a later version of Microsoft Access than the one you are using.
Upgrade your version of Microsoft Access to the current one, then open this
database.’ Well, I thought I has Access 2003 on my home PC, but when I
clicked on Help > About Microsoft Access, I see, low and behold, I have
Access 2002 with SP3. D’Ohh! My question...is there a similar tool for
Access 2002, or is there a way, somehow, to run that Utility that I
downloaded in my Access 2002?

Basically, I am trying to import a series of Excel spreadsheets into Access,
quickly and easily. I have used the TransferSpreadsheet method multiple
times, and always found this to be VERY useful. I am trying to create a
small tool, hopefully useful, for someone in my office to import Spreadsheets
quickly and easily, without as little hardcoding as possible.

This is somewhat of a follow up to a question that I posted earlier today.
Again, I am trying to figure out the easiest way of importing data from Excel
to Access.

Thanks so much,
Ryan---

 

[Peter Hibbs]

Ryan,

Try the Access 2000 version at :-
http://www.rogersaccesslibrary.com/...?TID=183&SID=e81a164e2314187z3e8587231e28cb7d

This utility was designed to import a spreadsheet file into an Access
database as a one-off operation. I'm not sure it will be suitable for
repeated imports where the Access database already has data.

But good luck anyway,

Peter Hibbs.

 

[ryguy7272]

Thanks for making me aware of this Peter!!

Ryan---