OpenRowSet BUG?

Hi Folks,

I am trying to load data from a table in MS Access to SQL Server 2000
using T-SQL OPENROWSET. When I select data from the remote database (MS
Access) using SQL Query analyzer, the columns do NOT appear in the same
order as seen in Access directly.

For e.g. if Access table has columns Cy, Cx, Cz the output in Query
analyzer appears as Cx, Cy, Cz. It appears to arrange the fields
alphabetically. This causes problems when I do a 'insert into select *
from' as the field definitions do not agree.

Is this a bug or is there a setting in Access/SQL which I am missing?
Also, please let me know if there is a workaround for this issue.

Thanks in advance!

Bhaskar

.

Relevant Pages

  • Re: php mssql stored procedure
    ... it into SQL Query Analyzer it executes and returns results. ... Use a serious database, ... make it so simple that there are obviously no deficiencies, ... Installed MS SQL Server Native Client from ...
    (comp.lang.php)
  • Re: MissingMethodException
    ... > Are you using SqlDataAdapter to load data from SQL Server CE? ... > could simply be that SQL Server CE is not installed on the new device. ... >> This app work on a previous demo symbol device also running PocketPC, ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: using "Insert Into..." with dataAdapter Insert Command?
    ... > I want to load data to a table in Sql Server from a ... > dataset table in my vb.net app using a dataAdapter. ... > Sql Command object without the dataAdapter to insert All ... > data to my sql server table from a dataset table (without ...
    (microsoft.public.dotnet.languages.vb)
  • Comparing inseted data versus selected data
    ... I made ahuge loading script in SQL server 2000 which load data from ... many tables in one table and i want to test the loaded data against the ...
    (comp.databases.sybase)
  • Re: Incoming TDS RPC Protocol Stream Incorrect Error for SQL Server 2005
    ... I am unable to connect to SQL Server from OC4J application server. ... But i am able to connect to SQL Query analyzer. ... JDBC]The incoming tabular data stream remote procedure ...
    (microsoft.public.sqlserver.jdbcdriver)