Union Query Maybe?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mr-Re Man - 18 May 2006 12:21 GMT

Hi, I don't know if this is possible but here goes.....

Database been created to log incoming mail to be tracked, some users would
like to use excel to input the data and have it merge into the main query.

Possible problem: the database table/query creates a LetterID using
<autonumber> for each piece of mail that is logged as several users will be
entering mail in each morning.

I agree with your first thoughts, have them use Access instead, but I need
an option if they cannot use it.

Reply to this Message

Klatuu - 18 May 2006 17:04 GMT

Create a "transfer" table that has the same field layout as the excel
spreadsheet.
Create an Append query to append data from the transfer table to the table
with the autonumber. Do not include the autonumber field in the append query.

Then, to get the data in:
Delete any data in the transfer table.
Import the spreadsheet into the transfer table using Transferspreadsheet.
Run the append query.
When it appends records to the table with the autonumber field, an
autonumber will be assigned to each record.

> Hi, I don't know if this is possible but here goes.....
>
[quoted text clipped - 7 lines]
> I agree with your first thoughts, have them use Access instead, but I need
> an option if they cannot use it.

Reply to this Message