zzz projects SqlBulkCopy Tutorial
Documentation Troubleshooting
Knowledge Base
  • Documentation
  • Troubleshooting
  • Knowledge Base

SqlBulkCopy Tutorial - Knowledge Base (KB)

4 results for: in tag: ms-access

SqlBulkCopy calculated field

I am working on moving a database from MS Access to sql server. To move the data into the new tables I have decided to write a sync routine as the schema has changed quite significantly and it lets me run testing on programs that run off it and resync whe...
.net c# ms-access sqlbulkcopy sql-server
asked by PeteT

Bulk import from MS Access and Insert into Sql Server

I want to read records from MS Access database and Insert into Sql server database, the process should be bulk insertion. I'm using asp.net/vb.net
asp.net c# ms-access sqlbulkcopy sql-server
asked by hotcoder

Access double to SQL decimal using SQL Bulk Copy

I have an Access database that I am converting to an SQL database using sqlbulkcopy in vb.net. We have currency values (up to 2 decimal places) stored in Access as Double. When I convert these Access fields to SQL fields with type [decimal] (19, 2), a n...
ms-access sql sqlbulkcopy vb.net
asked by MPITech

Keyword not supported: 'provider' with SqlBulkCopy

I try to write access connection string in SqlBulkCopy but I got error ...Keyword not supported: 'provider'...here is my code:...bulk = New SqlBulkCopy("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & mFileName & ";Jet OLEDB:Database Password=hmis;") bu...
asp.net c# ms-access sqlbulkcopy vb.net
asked by Mohammed Ahsan

Page 1 of 1
  • 1

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...