retrieve data from one table to another

[Guest]

I need to know how to import data from one table into another; importing on
specific fields. I also would like to be able to have only unique data
imported.

Thanks,
Lisa

 

[Douglas J. Steele]

Create a query that retrieves the data in which you're interested in from
the one table (listing only the specific fields, and making it Distinct),
and use that query as the basis for an Append query or a Make Table query.

 

[Guest]

Thanks! I also have another question relative to automating.

I am looking for advice for the best way to solve a problem.

I am developing a system telephony extensions etc at a
workplace, some sites may have 200+.

I am trying to automate entering all the extension numbers, rather than
manually inputting them. I also have a format for the range of extensions,
but don't know if Access will allow me to give an example and then create the
extension for me automatically in sequence.

Thnks

 

[Douglas J. Steele]

Access won't do anything to insert records automatically: you have to tell
it to insert them.

It shouldn't be all that difficult, though, to create a loop that runs an
INSERT INTO query as many times as you need.

 

[Guest]

Thanks Doug. Can you give me instructions on how to do this? Below is more
information on the format:

The extension format will be something like 256 0 00 00. Also below is the
possible range of the numbers to be included in the extensions.

1st set of numbers ( up to 256)
2nd number (can be 0 or 1)
3rd set of numbers (0 to 15)
4th set of numbers (0 to 31)

**Not sure how difficult this will be, but very necessary because we have
several ranges of numbers that would have to be manually entered.**

Any assistance is greatly appreciated.

 

[Douglas J. Steele]

I noticed you've been asking these questions in multiple newsgroups.

Lance seems to be helping you now: I won't duplicate the effort.

 

[Guest]

Thanks Doug.

I noticed you've been asking these questions in multiple newsgroups.

Lance seems to be helping you now: I won't duplicate the effort.

 

[Guest]

Doug,

I'm not sure if Lance is still able to assist. I haven't received any
additional responses. Can you assist?

Thanks in Advance,
Lisa W.

 

[Lisa W.]

Doug,

Can you review my issue again and assist. I never received any help from
anyone probably due to the Thanksgiving holiday.

Thanks,
Lisa W.