Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pwint
Starting Member
7 Posts |
 Posted - 2005-05-19 : 23:42:00
|
| Hi I'm planning to do the data transfer through sql to access. Then the results should be downloadable format and users should download it. How can i run within the source code?Give me an idea please.Thanks in advance. |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-05-19 : 23:53:40
|
| What source code? How are your users going to synch up the data when they reconnect? How will the users know when to download "it"? What is "it"? Is it just an Access database with tables in it?Have you thought about a web page users can look at reports or data from? What exactly are you trying to do here?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
raclede
Posting Yak Master
180 Posts |
Posted - 2005-05-20 : 01:22:52
|
| why convert into access? why not in excel in such as way users should be familiar with...its just easy to convert date to ---> excel. This is how we do it.. See Example Below: Kaboom output is excel.... right..... easy as 1,2,3<%sqlStm="select InpDate, PSO.ID,a.CUSTPRV as WSPrv,a.CUSTCITY as WSCity,PSO.WSCode,a.CNAME as WSName,b.CUSTPRV as HPPrv,b.CUSTCITY as HPCity,PSO.HPCode,b.CNAME as HPName,PSO.ITEM,IM.ITEMDES,PSO.QTY,PSO.OEDate,PSO.CFM from PSO,CUST as a,CUST as b,IM where PSO.WSCode=a.CUST and PSO.HPCode=b.CUST and PSO.ITEM=IM.ITEM" & outFilter & " order by " & sort1 & " " & sort2 & " , PSO.ID asc"Response.ContentType = "application/vnd.ms-excel" '--- keyword<table width="95%" border="1" cellspacing="0" cellpadding="3"> <tr bgcolor="#000000"> <td><div align="center" class="style7"><span class="style3">±àºÅ[ID]</span></div></td> <td><div align="center" class="style7"><span class="style3">Ê¡[ÉÌÒµ]</span></div></td> <td><div align="center" class="style7"><span class="style3">ÊÐ[ÉÌÒµ]</span></div></td> <td><div align="center" class="style7"><span class="style3">ÉÌÒµ´úÂë</span></div></td> <td><div align="center" class="style7"><span class="style3">ÉÌÒµÃû³Æ</span></div></td> <td><div align="center" class="style7"><span class="style3">Ê¡[Ò½Ôº]</span></div></td> <td><div align="center" class="style7"><span class="style3">ÊÐ[Ò½Ôº]</span></div></td> <td><div align="center" class="style7"><span class="style3">Ò½Ôº´úÂë</span></div></td> <td><div align="center" class="style7"><span class="style3">Ò½ÔºÃû³Æ</span></div></td> <td><div align="center" class="style7"><span class="style3">²úÆ·´úÂë</span></div></td> <td><div align="center" class="style7"><span class="style3">²úÆ·Ãû³Æ</span></div></td> <td><div align="center" class="style7"><span class="style3">ÊýÁ¿</span></div></td> <td><div align="center" class="style7"><span class="style3">¶©µ¥ÈÕÆÚ</span></div></td> <td><div align="center" class="style7"><span class="style3">Inp.Date</span></div></td> <td><div align="center" class="style7"><span class="style3">¶©µ¥×´Ì¬</span></div></td> </tr> <% adors.open sqlStm,adoconn do while not adors.eof %> <tr> <td><div align="center" class="style7"><%=adors("ID")%></div></td> <td><div align="center" class="style7"><%=trim(adors("WSPrv"))%></div></td> <td><div align="center" class="style7"><%=trim(adors("WSCity"))%></div></td> <td><div align="center" class="style7"><%=" " & trim(adors("WSCode"))%></div></td> <td><div align="center" class="style7"><%=trim(adors("WSName"))%></div></td> <td><div align="center" class="style7"><%=trim(adors("HPPrv"))%></div></td> <td><div align="center" class="style7"><%=trim(adors("HPCity"))%></div></td> <td><div align="center" class="style7"><%=" " & trim(adors("HPCode"))%></div></td> <td><div align="center" class="style7"><%=trim(adors("HPName"))%></div></td> <td><div align="center" class="style7"><%=" " & trim(adors("ITEM"))%></div></td> <td><div align="center" class="style7"><%=trim(adors("ITEMDES"))%></div></td> <td><div align="center" class="style7"><%=formatnumber(adors("QTY"),2)%></div></td> <td><div align="center" class="style7"><%=trim(adors("OEDate"))%></div></td> <td><div align="center" class="style7"><%=trim(adors("InpDate"))%></div></td> <td><div align="center" class="style7"> <% if ucase(trim(adors("CFM")))="Y" then response.write("ÒÑÈ·ÈÏ") else response.write("´ýÈ·ÈÏ") end if %> </div></td> </tr> <% adors.movenext loop adors.close set adors=nothing adoconn.close set adoconn=nothing end if %>Cursors are for those who doesn't know how to use SQL K.I.S.S. - Keep it simple stupidraclede™ |
|
|
|
|
|
|
|
|
Idea to transfer data from sql DB to access and do