Hi everyone,
I have data coming to me in the form of Word and Excel files, and I
need to place this data into a SQL Server database. The Word file will
be coming in text which is similiar to an Excel sheet, but instead of
being comma delimited, it will be delimited by spaces. Regarding the
Word document, I can set rules for the field length myself, but my
question is regarding the proper programming APIs to use. Can this be
done via VB scripts on the documents, or as a seperate .NET
application? I have access to both the C# and VB.NET platforms. (And
J2EE as well, although a Microsoft platform would be more appropriate,
IMHO). Any ideas on the best way to do this?
Thanks, 3 2332
Why not just use SQL Server's DTS functionality?
<he*******@hotmail.com> wrote in message
news:11**********************@z34g2000cwc.googlegr oups.com... Hi everyone,
I have data coming to me in the form of Word and Excel files, and I need to place this data into a SQL Server database. The Word file will be coming in text which is similiar to an Excel sheet, but instead of being comma delimited, it will be delimited by spaces. Regarding the Word document, I can set rules for the field length myself, but my question is regarding the proper programming APIs to use. Can this be done via VB scripts on the documents, or as a seperate .NET application? I have access to both the C# and VB.NET platforms. (And J2EE as well, although a Microsoft platform would be more appropriate, IMHO). Any ideas on the best way to do this?
Thanks,
Herman404,
You are saying "Word and Excel" but then you are descibing delimited text
files that would need to be imported into either Word or Excel in order to
become real Office application documents (e.g. ".doc" and ".xls" files). So
you are really desribing two issues.
1) To import delimited text into either Word or Excel you would need to use
the respective Primary Interop Assembly for that office application.
2)regarding storing in the database, text can always be stored in a TEXT or
NTEXT column. "Real" Word or Excel files are binary and so would need to be
stored in am Image type column.
Hope that helps.
Peter
--
Co-founder, Eggheadcafe.com developer portal: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
"he*******@hotmail.com" wrote: Hi everyone,
I have data coming to me in the form of Word and Excel files, and I need to place this data into a SQL Server database. The Word file will be coming in text which is similiar to an Excel sheet, but instead of being comma delimited, it will be delimited by spaces. Regarding the Word document, I can set rules for the field length myself, but my question is regarding the proper programming APIs to use. Can this be done via VB scripts on the documents, or as a seperate .NET application? I have access to both the C# and VB.NET platforms. (And J2EE as well, although a Microsoft platform would be more appropriate, IMHO). Any ideas on the best way to do this?
Thanks,
Hi Peter,
We don't need the file itself in the database, we need the text in the
file itself. It would be easier to get it as pure text, but our
customer sends the data to us in Word and Excel, and there's no way we
can change that. But it sounds like the Primary Interop Assembly could
be used to output the data in a Word or Excel to a .txt and .csv file
respectively? If that could be done, then it could solve our issues.
Thanks,
Herman
Peter wrote: Herman404, You are saying "Word and Excel" but then you are descibing delimited text files that would need to be imported into either Word or Excel in order to become real Office application documents (e.g. ".doc" and ".xls" files). So you are really desribing two issues. 1) To import delimited text into either Word or Excel you would need to use the respective Primary Interop Assembly for that office application. 2)regarding storing in the database, text can always be stored in a TEXT or NTEXT column. "Real" Word or Excel files are binary and so would need to be stored in am Image type column. Hope that helps. Peter
-- Co-founder, Eggheadcafe.com developer portal: http://www.eggheadcafe.com UnBlog: http://petesbloggerama.blogspot.com This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Ruby Tuesday |
last post by:
Hi, I was wondering if expert can give me some lite to convert my word table
into access database.
Note: within each cell of my word table(s), some has multi-line data in it.
In addition, there...
|
by: Starriol |
last post by:
Hello.
I'm working on a project with an excel database and need help with the
following.
This database has some dates that are changed regularly and I need to
make an automated
system so...
|
by: Chris |
last post by:
Hi,
- How can I open an existing word document from a C#-client and manipulate
that document from within the C#-client ?
- How can I open an excel document that is embedded in a word-document...
|
by: Chris |
last post by:
Hi,
everything works apart from the last line :-((
rng.Value2.ToString()
An exception is thrown : "Old format or invalid type library"
It gets compiled though (so he recognizes the property...
|
by: herman404 |
last post by:
Hi everyone,
I have data coming to me in the form of Word and Excel files, and I
need to place this data into a SQL Server database. The Word file will
be coming in text which is similiar to an...
|
by: vbnetdev |
last post by:
My boss wants this done in a day. I would be happy with a week!
Anyway, I have a dataset filled with data and need to populate an MS word
chart with it when writing a report. Any tutorials or...
|
by: reb0101 |
last post by:
hey all,
I would very much appreciate any help or ideas on how to do this as I am stumped.
I need to develop an access database to track documents but also link to them.
I’ll explain what it...
|
by: Vader |
last post by:
I am new to this forum. Thanks in advance for and help. The following is what I am looking for:
1. I need help with VB code to open a MS Word (.doc) file.
2. Read lines from the MS Word (.doc)...
|
by: Peter |
last post by:
ASP.NET 2.0
I am trying to open a Word document and Excel document from a dialog web
page, what's the best way to do that?
I have tried the following:
Response.Clear();...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
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: 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: 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: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
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...
| |