473,395 Members | 1,720 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

import txt-file via batchscript to SQL 2005

Hello,

I want to import a txt-file with semicolon as separator from a workstation to my MS SQL 2005 Express Edition server via batch script.
After import the user should get a message, like "import ok" or "import false".
Could someone help me with this?

Best regards,
Axel Biedermann
Sep 18 '06 #1
0 1402

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: Dfenestr8 | last post by:
Hi. I have a program which I want a plugin directory for. I figured the way to go about that would be to just add a plugin/ dir to sys.path, and import everything in it. Then my program can just...
4
by: atse | last post by:
Hi, I still have problem to import the text file delimited by tabs or commas into the database. I refer to http://www.connectionstrings.com/ for the connection, ODBC doesn't work and OLD DB...
6
by: leegold2 | last post by:
I have Apachce Mysql PHP on my PC (localhost) at home. I have a small db with a table or "two". I want to set up AMP on my PC at work and I want to import my home db to my work PC (both win32). ...
2
by: Bart Van der Donck | last post by:
Hello, I am using MySQL 4.0. Say that I have a table named "mytable" having a column "ID" and a column "test columnname". When dumping: mysqldump --opt DATABASE -uUSER -hHOST -pPASS >...
2
by: mohammad.gh | last post by:
hi, How can i import lib in VC++.net. notice that in VS6 you can do that in project setting part. please help meeeeeee With Best Wishes - Mohammad
1
by: Dan | last post by:
Could someone please help me with auto importing a series of data files into an Access table. I tried to follow code given below in a previous messagebut i'm getting error messages. Here's my...
1
by: Dan | last post by:
I tried the following code to import a series of data files into an Access table, but i keep getting Syntax errors. I'm running it from a Macro using the RunCode action with the ImportFiles()...
0
by: DataFreakFromUtah | last post by:
Hello! No question here, just a procedure for the archive. Search critera: count records imported count data imported count number of rows imported count number of records imported record import...
2
by: veaux | last post by:
Peeked around here but didn't really see an explanation as to the varied "Invalid Argument" errors that appear in Access sometimes. I'm using Access 2003 and trying to import an Access table of...
6
by: pramodh | last post by:
hay am importing sub script externally in .txt format by html tags(H<sub>2</sub>o)but this tag is not working in flash.so please guide me how to show a subscript externally in .txt format in flash
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.