append query?

bph · November 23rd, 2004, 11:43 AM

This seems like it should be possible, but I can't get it to work.

I have one table in an MSSQL Server database. I have an access front end. I linked the table.

I want to use Access front end append query gui to append data into SQL server table.

I keep failing the connection. Do I need to enter connection string in query properties? If so, how does that look, so I can check with what I have tried?
Thanks, BPH

jemacc · November 23rd, 2004, 12:00 PM

try creating an insert query

Code:

INSERT INTO Customers ( CompanyName, ContactName, ContactTitle )

Code:

SELECT Employees.LastName, Employees.FirstName, Employees.Title
FROM Employees
WITH OWNERACCESS OPTION;

Also make sure the linked table are indexed.

Jaime E. Maccou
Applications Analyst

bph · November 23rd, 2004, 12:44 PM

Jaime,

880 rows currently exist in table. New rows need to be added via the gui window, (user convenience) whereby allowing the entry of 'criteria' under each column name, and finally running and appending to sql side.

I need to keep it real simple for the first part of this project.

Brian