Importing xl data into an access template

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. I am trying to import some xls information into a template in access.
I can get the records in there, but it does not bring up the "customer" table
when I hit the add customer button. It brings up a portion of the
information, like the city changes, however it places the same customer name
for everyone. Help?
Thanks
 
This post does not contain enough information to help you.

When you hit the ADD CUSTOMER BUTTON? Where is this button? On a form?
Did you make the button? Does it have code behind it? What would you like
for it to do?

We can't see your screen. Your post is way too vague. We have no idea what
your database structure looks like. Do you have one table of 100? Are you
using forms? Trying to add trough a query? Trying to add directly to the
table?

Rick B
 
The "add customer" button came in the template I downloaded from
Microsoft.com. After downloading the template, I imported my existing xl
files into the db. I am looking for how to link the two together. I created
relationships, but that didn't work. Sorry for the vagueness of my original
post.
Thanks for your time
 
Again, we still don't know the structure of your database.

You need to put your data in the tables that came with the database if it is
a template you downloaded. If you imported that data to a different table,
then you need to create an append query to copy those records into the table
where they should reside. You don't want to rebuild every object in the
database and tell them to look at your table rather than the table they
currently look at, do you?

Rick B
 
OK. I am building it from the begining based on three tables of xl
information give to me by a third party. It is a db of customers, inventory
and vendors. I need to be able to generate a sales recpt. and add and delete
customers, inventory, and vendors as needed. I was on the Microsoft site and
saw that they had a template that fit this criteria. I downloaded it as I
have not had a lot of luck trying to scratch it together. I brought in the
xl sheets into the template db. I can't get it to move forward and backward
though.

Thanks
 
Back
Top