Creating a SQL view using MS Access 2000

[LSQUARE]

There are 2 objectives:

1. I would like to set up a SQL view but avoid going through SQL to create the query. I am not too familiar with the language.

2. Manipulate the datatable for the SQL view

The theory is to import the raw data table from SQL, manipulate the table in Access (eg. insert /delete columns) and then export it back to SQL as a virtual table.

Questions: Can this be done? If so, how do I do this?

Any advice would be much appreciated.

 

[SBendBuckeye]

Not sure what you are trying to do here. Are you importing from SQL Server and then wanting to export back to SQL Server or am I missing the point entirely.

Good LucK!