Click here to Skip to main content
15,915,160 members
Home / Discussions / Visual Basic
   

Visual Basic

 
Questionbtrees demo implementation using VB.NET Pin
keshav v kamat11-Apr-06 8:04
keshav v kamat11-Apr-06 8:04 
QuestionDigital Signature Problem.. Pin
kantCodeAlik11-Apr-06 7:28
kantCodeAlik11-Apr-06 7:28 
AnswerRe: Digital Signature Problem.. Pin
kantCodeAlik11-Apr-06 9:25
kantCodeAlik11-Apr-06 9:25 
QuestionSorting Problem in GridView with Pagng *** urgent Pin
VenkataRamana.Gali11-Apr-06 6:48
VenkataRamana.Gali11-Apr-06 6:48 
Questionlike creating controls in run time Pin
thruman611-Apr-06 6:35
thruman611-Apr-06 6:35 
AnswerRe: like creating controls in run time Pin
Dave Kreskowiak11-Apr-06 17:36
mveDave Kreskowiak11-Apr-06 17:36 
Questioncopy a table from SQL SERVER to Access DataBase Pin
Sheel Gohe11-Apr-06 4:22
Sheel Gohe11-Apr-06 4:22 
AnswerRe: copy a table from SQL SERVER to Access DataBase Pin
Dave Kreskowiak11-Apr-06 17:34
mveDave Kreskowiak11-Apr-06 17:34 
Well, I've never had to do this. And, frankly, don't want to.

Off the top of my head, you can't do this between two different databases because the underlying database types are different. For instance, SQL Server supports the bit type, where Access does not. The Data/Time storage formats are different, different Integer types are supported, Currency, ..., yada, yada, yada. The Copy method will NOT translate this for you.

So, no, I'd say you can't do this using this method. You'd have to read each individual record and field from the source table, translate the data, then put the new data in an Update or Insert query in the Access database.


The other alternative is to construct a DTS job to do the export for you. This will, of course, depend on the Access file being put someplace where the SQL Server can write to it and you can pick it up after the job completes.


Dave Kreskowiak
Microsoft MVP - Visual Basic

QuestionRelocating Objects Pin
tibmark11-Apr-06 2:58
tibmark11-Apr-06 2:58 
GeneralRe: RELOCATING OBJECTS Pin
Guffa11-Apr-06 3:15
Guffa11-Apr-06 3:15 
Questionwindows media encoder Pin
percyvimal11-Apr-06 2:55
percyvimal11-Apr-06 2:55 
QuestionIncluding dlls in an exe Pin
hertz_j11-Apr-06 0:07
hertz_j11-Apr-06 0:07 
AnswerRe: Including dlls in an exe Pin
Colin Angus Mackay11-Apr-06 0:29
Colin Angus Mackay11-Apr-06 0:29 
GeneralRe: Including dlls in an exe Pin
hertz_j11-Apr-06 0:49
hertz_j11-Apr-06 0:49 
AnswerRe: Including dlls in an exe Pin
kasik11-Apr-06 4:42
kasik11-Apr-06 4:42 
GeneralRe: Including dlls in an exe Pin
hertz_j11-Apr-06 8:17
hertz_j11-Apr-06 8:17 
QuestionVisula Basic 6.0 Run Time Error : 402 Pin
noshaba mariam10-Apr-06 21:29
noshaba mariam10-Apr-06 21:29 
AnswerRe: Visula Basic 6.0 Run Time Error : 402 Pin
Dave Kreskowiak11-Apr-06 13:37
mveDave Kreskowiak11-Apr-06 13:37 
GeneralRe: Visula Basic 6.0 Run Time Error : 402 Pin
noshaba mariam11-Apr-06 17:52
noshaba mariam11-Apr-06 17:52 
Questionsession problem Pin
Amit Agarrwal10-Apr-06 19:40
Amit Agarrwal10-Apr-06 19:40 
AnswerYour question is not directly related to vb.net Pin
JUNEYT11-Apr-06 11:44
JUNEYT11-Apr-06 11:44 
QuestionIn my VS2003 project I send mail and it sends 7-8 times every time I send it? Pin
kenn_rosie10-Apr-06 19:29
kenn_rosie10-Apr-06 19:29 
QuestionIn my Global asax file aDo I need the code below newmail.fields.add and why do I need them? Pin
kenn_rosie10-Apr-06 19:15
kenn_rosie10-Apr-06 19:15 
Questionit saving two records instead of one Pin
Amit Agarrwal10-Apr-06 19:12
Amit Agarrwal10-Apr-06 19:12 
GeneralRe: it saving two records instead of one Pin
Guffa10-Apr-06 22:30
Guffa10-Apr-06 22:30 

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.