Will take the Other Side of this argument.

If you have a copy of MS Access, one of the options for creating a table is to either Import or Link Excel...

Thanks for all the inputs. Seriously, they all (eventually) added up to a great solution.

My apologies for not thanking everyone sooner.

My solution is part of a Quality Assurance Rule...

Read your article with the insert data format. That is a useful.

Promise to change my ways and do this from now on.

I help many people on the Access forum, needless...

How to I get the insert text values as you asked from my statement:

SELECT * into [ATempTable2]

FROM tblAPD_Fed_ST_CO

WHERE...

This is the entire table

CREATE TABLE [dbo].[tblAPD_Fed_ST_CO](

[intID_APD_FedStCo] [int] IDENTITY(1,1) NOT NULL,

[ID_Wells] [int] NULL,

[txtFedStCo] [nvarchar](9) NULL,

[lngID_APD_Status] [int] NULL,

[lngID_Reg_Office] [int] NULL,

[Dt_APD_Sub] [datetime2](0) NULL,

[Dt_APD_Apv] [datetime2](0) NULL,

[txt_APD_Apv_Status] [nvarchar](12) NULL,

[blnApprovalCancled] [bit] NULL,

[Dt_ApprovalCancled] [datetime2](0) NULL,

[Dt_APD_Exp] [datetime2](0)...

I had to look up how to do this. The format is from insert into a new table.

But, it left off the Primary Key intID_APD_FedStCo of...

Of course, the insert INTO, sorry about that.

Thanks! Got the reply Saturday. Came to work downtown Sunday to provide the example data with intended results.

There is a big football game starting soon.

I should have that data up...

Thanks for that!!

Searched the internet for that solution. The search terms just never got me there.

It looks so simple now that you have pointed it out.

At least I got something...

DOH! What a Nubie! Can't believe how bad I messed up the Select statement.

By not adding the second ID_Wells = @ID_Wells parameter to the simple query

The query was doing exactly...

Blaming the MBA is like blaming the janitor. This isn't just a DBA issue.

The problem with Wall Street is how the Executives have absolutely no accountability.

The Database is just...

Well, it took a while but I fully understand it all now. Will take the Date into consideration.

After running 10,000 records for the Federal Permits, I have a consistent error...

All of this really helped. Thanks!

Thanks so much. I am overwhelmed trying to look at the very useful code including the COALESCE(NullIF(...

The example of the GETDATE() +3 (and the rest)...

http://www.access-programmers.co.uk/forums/

Over 1 million posts. There is a SQL Server forum for advanced Access programmers that have helped many make the transaction successfully. Many of us have been using...

Was glad to see people admitting they use Access.

Since Access 97, my preference is to quickly prototype in MS Access.

Then take the model and convert it into SQL Server.

Since 1999,...