Uploading Bulk Data into an existing Table

[Adict]

I have problem with my append query

I have a query Name NewData with exist in a temporary and i have created an Append query name Appenddata. When i run this query i would like the data from temporary table to be inserted into dbo_Master table which reside in MS SQL server. However when i run the appenddata query in is appending zero data into the master table. The master table has several relationships with other tables - need some help on this.

[PhilOfWalton]

I feel sure there was an error message generated of why the data was not appended.
Have you bothered to read it, and if so, what did it say?

Phil

[Rabbit]

We can't actually tell you what's wrong with the query when you haven't given us the query. You need to post the SQL at least.

[Adict]

Below is my query

INSERT INTO dbo_TblMaster 
( HRAPSNo, AlphaCode, FirstName, LastName, Branch, 
Dept, Loc, CostCtr, DateStarted, EndDate, Status, 
PayRate, AnnualSalary, BirthDate, Sex, 
MaritalStatus, Dep, PositionNumber, PositionTitle, 
Netuser, DateCreated, DateModified, [Counter] )
SELECT NewData.HRAPSNo, NewData.AlphaCode, 
NewData.FirstName, NewData.LastName, NewData.Branch, NewData.Dept, NewData.Loc, NewData.CostCtr, NewData.DateStarted, NewData.EndDate, NewData.Status, NewData.PayRate, NewData.AnnualSalary, 
NewData.BirthDate, NewData.Sex, 
NewData.MaritalStatus, NewData.Dep, 
NewData.PositionNumber, NewData.PositionTitle, 
NewData.Netuser, NewData.DateCreated, 
NewData.DateModified, NewData.Counter
FROM NewData INNER JOIN dbo_TblMaster 
ON NewData.HRAPSNo = dbo_TblMaster.HRAPSNo;

[Rabbit]

You should use code tags when posting code to make it easier to read.

But I see the problem in your query. You're joining to table you're trying to insert into. If you're trying to insert new data, then trying to join to the master table is going to return 0 rows.

[Adict]

Thank you Rabbit

I've successfully managed to do remove the inner join and the rows has been picked up when i ran the column, however, I am receiving another error, file conversion error. I will have a workaround with the datatype i guess. Thank you for the assistance.

[Rabbit]

No problem, feel free to create a new thread if you have another question.

[NeoPa]

Sometimes linking to the destination table does make sense. Generally when you're trying to add only those records that you know don't exist there already.

In such a case you might use an OUTER JOIN (LEFT JOIN or RIGHT JOIN in Jet/ACE SQL) and include a WHERE clause to include only those records from the destination table where the values are NULL.