Reading data from Ms Access from SQL 2005 Stored procedure

• shatawneh

  Newbie

  Points: 7

  More actions

  April 28, 2008 at 6:01 am

  #189824

  Hi EveryBody;

  I am new to this forum , I find it amazing.

  I work in Windows form application project using vb.net and sql server 2005, but I want to read some data from another application which was developed by Ms Access 2 DB, So I am trying to read data from Access tables and process this data in my sql db then insert the processed data is my sql db.

  Could this be performed using sql server 2005 stored procedure, could sp read data from another db, or another server.

  Any help would be greatly appreciated.

• Adrian Nichols-360275

  SSCertifiable

  Points: 7694

  More actions

  April 29, 2008 at 5:16 am

  #808231

  Hi,

  The account that SQL Server runs under will need permissions to the folder and the following should give you a good example of how to do it:

  SELECT *

  FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

  '\\myServer\myFolder\myFile.mdb';

  'admin';'',myTable)

  HTH,

  ---

  
  Ade

  A Freudian Slip is when you say one thing and mean your mother.
  For detail-enriched answers, ask detail-enriched questions...[/url]