I need to make a table's data available to users. The table is about 150,000
rows x 20 columns. So Excel is out of the question. I think the next common
file types would be MDB or DBF. Using ASP, what are the steps to converting
this data to one of those file types, then ZIPPING the files for download?
thanks 8 1306
shank wrote: I need to make a table's data available to users. The table is about 150,000 rows x 20 columns. So Excel is out of the question. I think the next common file types would be MDB or DBF. Using ASP, what are the steps to converting this data to one of those file types, then ZIPPING the files for download?
What do they need to do with it? Do they need to access it through an
ASP page?
You could export it as XML just by adding "for xml auto" to the end of
the SQL statement.
"Larry Bud" <la**********@yahoo.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com... shank wrote: I need to make a table's data available to users. The table is about 150,000 rows x 20 columns. So Excel is out of the question. I think the next common file types would be MDB or DBF. Using ASP, what are the steps to converting this data to one of those file types, then ZIPPING the files for download?
What do they need to do with it? Do they need to access it through an ASP page?
You could export it as XML just by adding "for xml auto" to the end of the SQL statement.
I don't think the XML solution is practical for the size of the file. I
think I prefer writing to a DBF or MDB. I don't want to write it to the
screen, just to a file for zipping or download.
thanks
shank wrote: "Larry Bud" <la**********@yahoo.com> wrote in message news:11**********************@g44g2000cwa.googlegr oups.com... shank wrote: I need to make a table's data available to users. The table is about 150,000 rows x 20 columns. So Excel is out of the question. I think the next common file types would be MDB or DBF. Using ASP, what are the steps to converting this data to one of those file types, then ZIPPING the files for download?
What do they need to do with it? Do they need to access it through an ASP page?
You could export it as XML just by adding "for xml auto" to the end of the SQL statement.
I don't think the XML solution is practical for the size of the file. I think I prefer writing to a DBF or MDB. I don't want to write it to the screen, just to a file for zipping or download. thanks
Fine, but the other question Larry asked is equally important. In order for
us to provide a good recommendation, you need to provide as much information
as possible.
Are you simply creating a report to be printed? Is somebody actually going
to read the data contained in 3,000,000 fields? Would it make more sense to
provide a summary of this data?
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:e5**************@TK2MSFTNGP14.phx.gbl... shank wrote: "Larry Bud" <la**********@yahoo.com> wrote in message news:11**********************@g44g2000cwa.googlegr oups.com... shank wrote: I need to make a table's data available to users. The table is about 150,000 rows x 20 columns. So Excel is out of the question. I think the next common file types would be MDB or DBF. Using ASP, what are the steps to converting this data to one of those file types, then ZIPPING the files for download?
What do they need to do with it? Do they need to access it through an ASP page?
You could export it as XML just by adding "for xml auto" to the end of the SQL statement.
I don't think the XML solution is practical for the size of the file. I think I prefer writing to a DBF or MDB. I don't want to write it to the screen, just to a file for zipping or download. thanks
Fine, but the other question Larry asked is equally important. In order for us to provide a good recommendation, you need to provide as much information as possible.
Are you simply creating a report to be printed? Is somebody actually going to read the data contained in 3,000,000 fields? Would it make more sense to provide a summary of this data?
Bob Barrows
Users will be downloading the contents of a table so that they can populate
their own databases with product. This will happen many times throughout a
week. They will be comparing what we have discontinued and of course what is
new product. With about 150,000 rows and 20+ columns of data, I don't think
XML is practical. The ideal method would be to automate a process every
morning that would write a new MDB or DBF or maybe both, zip them and make
them available for download. I'm only guessing at this point, but I would
imagine 5MB-6MB of data. I don't want any writing to screen. It would be of
no use.
thanks!
shank wrote: Users will be downloading the contents of a table so that they can populate their own databases with product. This will happen many times throughout a week. They will be comparing what we have discontinued and of course what is new product. With about 150,000 rows and 20+ columns of data, I don't think XML is practical. The ideal method would be to automate a process every morning that would write a new MDB or DBF or maybe both, zip them and make them available for download. I'm only guessing at this point, but I would imagine 5MB-6MB of data. I don't want any writing to screen. It would be of no use. thanks!
How many users are we talking about? Is this in a LAN/WAN? Or over the
internet?
My first thought is to provide them with an Access database containing a
linked table. This database file would not need to be provided via ASP. If
you are on a LAN/WAN, it could be put on a file server. The users would need
instructions in creating an ODBC DSN (or a startup macor could be written to
automate the creation of the DSN - see an Access group for details)
You can create a read-only view of the table in you SQL Server database, and
point the linked table at that view.
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:Oj**************@TK2MSFTNGP15.phx.gbl... shank wrote: Users will be downloading the contents of a table so that they can populate their own databases with product. This will happen many times throughout a week. They will be comparing what we have discontinued and of course what is new product. With about 150,000 rows and 20+ columns of data, I don't think XML is practical. The ideal method would be to automate a process every morning that would write a new MDB or DBF or maybe both, zip them and make them available for download. I'm only guessing at this point, but I would imagine 5MB-6MB of data. I don't want any writing to screen. It would be of no use. thanks!
How many users are we talking about? Is this in a LAN/WAN? Or over the internet?
My first thought is to provide them with an Access database containing a linked table. This database file would not need to be provided via ASP. If you are on a LAN/WAN, it could be put on a file server. The users would need instructions in creating an ODBC DSN (or a startup macor could be written to automate the creation of the DSN - see an Access group for details)
You can create a read-only view of the table in you SQL Server database, and point the linked table at that view.
Bob Barrows
I've gone the route of trying to get users to setup an ODBC connection with
Access. It works great for the techie users, unfortunately, the bulk of
users are not going the route of ODBC. I can only assume they do not
understand. That leaves me with providing a file to download over the
internet. Up to 400 users will have access.
thanks
shank wrote:
I've gone the route of trying to get users to setup an ODBC connection with Access. It works great for the techie users, unfortunately, the bulk of users are not going the route of ODBC. I can only assume they do not understand. That leaves me with providing a file to download over the internet. Up to 400 users will have access.
Again, it is possible to create a VBA sub in an Access module that will
automate the creation of the DSN. That should not be considered an obstacle.
The obstacle is "the internet". A linked table will not work outside a LAN
or WAN.
What I would do is create a DTS package to export the SQL Server data to an
mdb file and schedule it to run nightly. Use a third-party tool to zip it in
an ActiveX script in the DTS package. Then provide a link to the zip file to
the users.
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
> I've gone the route of trying to get users to setup an ODBC connection with Access. It works great for the techie users, unfortunately, the bulk of users are not going the route of ODBC. I can only assume they do not understand. That leaves me with providing a file to download over the internet. Up to 400 users will have access. thanks
Is anyone familiar with: http://www.motobit.com/help/RSConv/database.asp
Recordset Converter
It appears to be what I want,but I don't know if it will work on a server
environment.
Is there another alternative?
thanks! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: BijuThomas |
last post by:
Complicated - ASP/Security/data transfer/XML doubt
In our company Head office we are hosting an intranet
server in IIS (Windows 2000) , ASP and Sqlserver back
end.
We are maintaining our branch...
|
by: StephenMcC |
last post by:
Hi All,
Got a quick query in relation to the Server.Transfer method available in IIS
5+/ASP. I've got an issue where I want to take a portion of an online app and
extract this out into a web...
|
by: Abhishek |
last post by:
I have a problem transfering files using sockets from pocket pc(.net compact
c#) to desktop(not using .net just mfc and sockets 2 API). The socket
communication is not a issue and I am able to...
|
by: Alexander Bosch |
last post by:
Hi,
I'm having a problem similar to the one that's stated in this KB
http://support.microsoft.com/default.aspx?scid=kb;en-us;839521
When I'm posting a page to itself with the bool value as true it...
|
by: E.T. Grey |
last post by:
Hi,
I have an interesting problem. I have a (LARGE) set of historical data
that I want to keep on a central server, as several separate files. I
want a client process to be able to request the...
|
by: David Veeneman |
last post by:
I am creating a form on the server that I want to POST to a URL that's being
called with Server.Transfer(). What's the simplest way to do that?
A little background: I'm programming buttons that...
|
by: David |
last post by:
I have googled to no avail on getting specifically what I'm looking for. I
have found plenty of full blown apps that implement some type of file
transfer but what I'm specifcally looking for is an...
|
by: =?Utf-8?B?YzY3NjIyOA==?= |
last post by:
Hi all,
Our asp programs seem to have different behaviors when users use IE and
firefox.
One of most annoying things is the data disappearing problem in IE but not
in firefox.(Note: Sometimes a...
|
by: Andrew Jackson |
last post by:
I am writing a newsgroup client. I have the protocol figured out. But I
get slow transfer speeds off any of the network objects read the data from
For example one of the commands for a news...
|
by: =?Utf-8?B?YWxiZXJ0b3Nvcmlh?= |
last post by:
Hi,
I'm using Threads, and when I try to do Server.Transfer, I recieved an
error. (child object does not exist...)
My Code:
Dim t As New Thread(AddressOf Hilo)
Private Sub Hilo()...
|
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: 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: 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: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
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: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
| |