Click here to Skip to main content
15,902,492 members
Home / Discussions / C#
   

C#

 
GeneralRe: C# Messenger Pin
harold aptroot26-Aug-09 10:22
harold aptroot26-Aug-09 10:22 
GeneralRe: C# Messenger Pin
I Believe In GOD26-Aug-09 12:17
I Believe In GOD26-Aug-09 12:17 
GeneralRe: C# Messenger Pin
harold aptroot26-Aug-09 12:47
harold aptroot26-Aug-09 12:47 
AnswerRe: C# Messenger Pin
Patrick Eckler26-Aug-09 12:03
Patrick Eckler26-Aug-09 12:03 
GeneralRe: C# Messenger Pin
harold aptroot26-Aug-09 12:10
harold aptroot26-Aug-09 12:10 
AnswerRe: C# Messenger Pin
N a v a n e e t h26-Aug-09 16:02
N a v a n e e t h26-Aug-09 16:02 
GeneralRe: C# Messenger Pin
I Believe In GOD27-Aug-09 3:03
I Believe In GOD27-Aug-09 3:03 
QuestionProgrammatically import Access DB into SQL Express Pin
benford26-Aug-09 9:46
benford26-Aug-09 9:46 
I am writing an app that requires centralizing a number of Access App's data files into one SQL server. Albeit separate databases within it.
I know the Access Upsizing wizard can migrate access tables to SQL. As can the SQL server import wizard. However, I need to be able to schedule this and request it at any time from the server.

Getting the Access mdb files onto the server isn't a problem, that's all handled with WebServices. However, I can't for the life of me find a way to automate the table creation and data insertion for the sql server.

I have come across a number of resources listing how to pull data from a datatable object and create the database on the server using SMO (SQL Managemant Objects, i think) But I can't see any resources on how to actually pull the Access data into a Datatable object in the first place. Either way, this method obviously will incur some speed penalties, also maybe some problems with datatypes etc... So finding a way to automate the sql import is by far the better idea!

If anyone has any ideas I would be so grateful!

Thanks a lot.
Ben
QuestionSudoku problem [modified] Pin
GravityKoch26-Aug-09 9:45
GravityKoch26-Aug-09 9:45 
AnswerRe: Sudoku problem Pin
EliottA26-Aug-09 11:21
EliottA26-Aug-09 11:21 
AnswerRe: Sudoku problem Pin
Henry Minute26-Aug-09 14:49
Henry Minute26-Aug-09 14:49 
GeneralRe: Sudoku problem Pin
GravityKoch26-Aug-09 20:26
GravityKoch26-Aug-09 20:26 
QuestionLoading status bar for data in other form !! Pin
rocky81126-Aug-09 9:29
rocky81126-Aug-09 9:29 
AnswerRe: Loading status bar for data in other form !! Pin
I Believe In GOD26-Aug-09 9:58
I Believe In GOD26-Aug-09 9:58 
AnswerRe: Loading status bar for data in other form !! Pin
DaveyM6926-Aug-09 10:04
professionalDaveyM6926-Aug-09 10:04 
QuestionProblem wrting to custom config element Pin
CTaylor8926-Aug-09 9:25
CTaylor8926-Aug-09 9:25 
QuestionDrag and Drop Pin
JimLaVine26-Aug-09 9:07
JimLaVine26-Aug-09 9:07 
AnswerRe: Drag and Drop Pin
kKamel26-Aug-09 11:18
kKamel26-Aug-09 11:18 
GeneralRe: Drag and Drop Pin
JimLaVine26-Aug-09 11:20
JimLaVine26-Aug-09 11:20 
GeneralRe: Drag and Drop Pin
kKamel26-Aug-09 11:22
kKamel26-Aug-09 11:22 
AnswerRe: Drag and Drop Pin
Kevin Marois26-Aug-09 11:51
professionalKevin Marois26-Aug-09 11:51 
QuestionMouse Scheme in windows Pin
caiena26-Aug-09 7:11
caiena26-Aug-09 7:11 
AnswerRe: Mouse Scheme in windows Pin
I Believe In GOD26-Aug-09 9:56
I Believe In GOD26-Aug-09 9:56 
QuestionProgress bar [loading progress bar for background data load ] Pin
smoothcriminal26-Aug-09 6:29
smoothcriminal26-Aug-09 6:29 
AnswerRe: Progress bar [loading progress bar for background data load ] Pin
Henry Minute26-Aug-09 7:12
Henry Minute26-Aug-09 7:12 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.