need to automate text files to be imported to sql databasep

January 17, 2012 at 22:55:32
Specs: Windows XP
windows batch file to import text files to sql database

See More: need to automate text files to be imported to sql databasep

Report •


#1
January 18, 2012 at 22:26:30
What kind of sql database? Do you know how to write sql insert statements? If so, I can help you write the FOR loop you need to execute multiple commands.

Report •

#2
January 18, 2012 at 22:36:47
hi...
i do know how to write insert statement. the thing is these text files get into my mails so im lookng for a way to retrieve them from my outlook and into sql sever 2005

Report •

#3
January 18, 2012 at 23:20:17
Both of those are made by Microsoft so I am 99% sure there is no easy way to do that. If you were using Zimbra and MySQL then I'm sure it would be easy. Sorry.

Report •

Related Solutions

#4
January 19, 2012 at 01:01:28
ok but is there a way to do it if i copy the text files to a separate folder and import them from there? any help would be appreciated.

Report •

#5
January 19, 2012 at 06:52:20
If you have the text files in a folder somewhere, and there is unique data on each line in the files, it would be relatively simple to convert each line into an insert statement. At that point, I think it would be simple to execute each insert line (with db credentials) as a command prompt command.

Report •

Ask Question