by: JT |
last post by:
i have written some asp that reads a fixed length text file, line by line,
inserting each line into my database. my problem is that the text file
format seems to have extra space at the end of the...
|
by: Sven |
last post by:
Hello,
I am receiving a text file that is produced from a mainframe that is
out of my control. I am attempting to find a (hopefully clean) way to
import it into a SQL Server database in an...
|
by: Lauren Quantrell |
last post by:
I have created the following trigger:
CREATE TRIGGER ON OutputTable
FOR INSERT
AS
Declare @filename nvarchar(35)
Declare @filecontents nvarchar(2000)
Declare @strcmdshell varchar(150)
|
by: Lauren Quantrell |
last post by:
I have created a view named viewOutput that shows one column in a
table.
I insert a row into the table and then I'm using this code to create a
file with the text in the single row.
This code...
|
by: S. Osit |
last post by:
Hi All,
I'm not that great with MS-SQL, as I never really have any occasion to
use it. However, I need to get this one thing working and don't have
a clue where to start.
I have a...
|
by: Alex |
last post by:
Hi,
How would I go about writing the results of an SQL query to a text
file?
I cannot find any info in the Online help files.
For example, I would like the results of:
SELECT * FROM...
|
by: Avi |
last post by:
Hi
I need to read in a large set of text files (9GB+ each) into a database
table based on fixed width lengths.
There are several ways to complete this, but I am wondering if anyone has...
|
by: Eonasdan |
last post by:
Greetings! I hope some can help with out with this. I am trying to write a scripting using bcp to import large amounts of data from a text file that is tab delimited. The problems I have run into is...
|
by: Raymond Chiu |
last post by:
Dear all,
Now I have the simple task to read text file line by line into database (SQL
Server 2000).
If the text file is divided into different fields according to the number of
characters,...
|
by: Chris McFarling |
last post by:
What's the most efficient method to export the result set of a SQL query to
a text file using ASP.NET? There could potentially be a few thousand rows.
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|