"Steve K" <anonymous@discussions.microsoft.com> wrote in message
news:088E81A6-5D21-4D67-9D02-642F57C424A6@microsoft.com...
> I need to import data directly into the SQL CE database, can you tell me
how you import the CSV file?
Re: date format ... The Update/CASE just doesn't change the exception rows, leaving them for you to find and replair. ... impossible to load the entire database in excel application. ... convert it in sql.... I received a csv file which has a date column. ... (microsoft.public.sqlserver.mseq)
Re: date format ... If this is a one time issue, and depending upon the filesize, the easiest ... and then load it into SQL Server using DTS or however you were planning ... be quicker than trying to find a way to code SQL to do it. ... I received a csv file which has a date column. ... (microsoft.public.sqlserver.mseq)
Re: Sql ce server process ... We are certainly aware of the dll load issue, ... application that is using sqlmobile and is on the virge of disaster. ... running 2 processes at the same time, one that uses the SQL Mobile engine...unmanaged SQL Compact DLLs is that you need to get them loaded early in the ... (microsoft.public.sqlserver.ce)
Re: Sql ce server process ... We are unlikely to target another platform until WM7 ... My plan is not to try to use sql in any more robust of a fassion than was ...load on the database that is any more heavy than the load that exists today, ... (microsoft.public.sqlserver.ce)
Re: load access table to sql ... I'm able to load the table now using very similar code. ... having is because of a column named "Group" in both the local and sql table. ... >> Dim rst As Recordset ... (microsoft.public.access.modulesdaovba)
