Click here to Skip to main content
16,004,678 members
Home / Discussions / C#
   

C#

 
GeneralRe: lambda expression or other default query attribute Pin
Guffa19-Apr-08 4:11
Guffa19-Apr-08 4:11 
GeneralRe: lambda expression or other default query attribute Pin
AndrusM19-Apr-08 11:02
AndrusM19-Apr-08 11:02 
GeneralRe: lambda expression or other default query attribute Pin
Roger Alsing19-Apr-08 11:43
Roger Alsing19-Apr-08 11:43 
GeneralRe: lambda expression or other default query attribute Pin
Guffa19-Apr-08 13:45
Guffa19-Apr-08 13:45 
GeneralRe: lambda expression or other default query attribute Pin
Roger Alsing20-Apr-08 4:01
Roger Alsing20-Apr-08 4:01 
GeneralRe: lambda expression or other default query attribute Pin
Guffa20-Apr-08 11:05
Guffa20-Apr-08 11:05 
Generalimport a txt file into MSAccess database and later into SQL server database using C# Code Pin
new2pgrmg19-Apr-08 3:06
new2pgrmg19-Apr-08 3:06 
GeneralRe: import a txt file into MSAccess database and later into SQL server database using C# Code Pin
Spacix One19-Apr-08 4:31
Spacix One19-Apr-08 4:31 
If you must take it into access:
Why not use a text editor, something like gVIM with a :%s/\"/,/g then :%s/,,/,/g command and convert it to a CVS file and do a direct import?
Or you could do an indirect import by 1st going into to excel and picking " as your custom split char, but you MUST remember to import as text!

Not really a reason to parse this though C# code, as you are just going to make it harder on yourself. Remember the simplest solution is most of the time the better soluiton.

The only reason I could see doing this in C# is if you have to process these files many times a day or you wish to learn ADO.NET along the way. The second option doesn't seem viable if you already send Access data into SQL server, so why not modify or fork the program you have to parse the flat file directly into SQL server 2k5?


-Spacix
All your skynet questions[^] belong to solved

GeneralIntPtr Pin
George_George19-Apr-08 2:20
George_George19-Apr-08 2:20 
GeneralRe: IntPtr Pin
Zoltan Balazs19-Apr-08 2:24
Zoltan Balazs19-Apr-08 2:24 
GeneralRe: IntPtr Pin
George_George19-Apr-08 2:31
George_George19-Apr-08 2:31 
GeneralRe: IntPtr Pin
Zoltan Balazs19-Apr-08 2:44
Zoltan Balazs19-Apr-08 2:44 
GeneralRe: IntPtr Pin
George_George19-Apr-08 2:49
George_George19-Apr-08 2:49 
GeneralRe: IntPtr Pin
Zoltan Balazs19-Apr-08 2:58
Zoltan Balazs19-Apr-08 2:58 
GeneralRe: IntPtr Pin
George_George19-Apr-08 3:11
George_George19-Apr-08 3:11 
GeneralRe: IntPtr Pin
Luc Pattyn19-Apr-08 7:48
sitebuilderLuc Pattyn19-Apr-08 7:48 
GeneralRe: IntPtr Pin
George_George19-Apr-08 21:09
George_George19-Apr-08 21:09 
Generalobject destroy Pin
George_George19-Apr-08 1:15
George_George19-Apr-08 1:15 
GeneralRe: object destroy Pin
Zoltan Balazs19-Apr-08 2:22
Zoltan Balazs19-Apr-08 2:22 
GeneralRe: object destroy Pin
Luc Pattyn19-Apr-08 2:46
sitebuilderLuc Pattyn19-Apr-08 2:46 
GeneralRe: object destroy Pin
Zoltan Balazs19-Apr-08 3:06
Zoltan Balazs19-Apr-08 3:06 
GeneralRe: object destroy Pin
George_George19-Apr-08 3:16
George_George19-Apr-08 3:16 
GeneralRe: object destroy Pin
Guffa19-Apr-08 3:54
Guffa19-Apr-08 3:54 
GeneralRe: object destroy Pin
George_George19-Apr-08 3:59
George_George19-Apr-08 3:59 
GeneralRe: object destroy Pin
Guffa19-Apr-08 5:16
Guffa19-Apr-08 5:16 

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.