Excel as Data Entry into Access Database

B

Btibert

Hello everyone,

I was hoping someone could point me in the proper direction. Unless m
mind is playing tricks on me, I swear I could have used an add-in (o
something else) that used a dialog box where you could specify whic
cells in an Excel contained the data that went to various tables int
Access. You were able to specify exactly which tables and variables i
Access the data from Excel had to go per record. I think basicall
what it enabled you to do was create a form that inputted the data int
Access but was contained only in Excel.


What was this add-in or how do I go out about this?

Thanks in advance!

Broc
 
C

Conrad Carlberg

Brock,

I wonder if you might be thinking of the Template Wizard with Data Tracking.
I think it shipped with Excel 95 and 97. It was a real bow-wow.

C^2
Conrad Carlberg
 
C

Conrad Carlberg

Quite by accident, I just ran across a reference to Access Links, which is
probably the add-in you have in mind. See the Microsoft Knowledge Base
article number 135716 for more information.

C^2
Conrad Carlberg
 
B

Btibert

Let me take a look. Thanks alot for getting back to me. Now that yo
mention it, I believe it was with a much older version of Excel, so yo
probably are correct. Regardless, thanks for giving me some tips t
point me in the right direction
 
Top