Preserved Topic: Found something useful (Page 1 of 1)

I think this could be usefull to those of you who want to learn database stuff like me
http://www.udnewbie.com/BeginnerTutorials/dbstuff/dbstuff1.cfm


oh yeah.. btw.. you will need UltraDev

MAX

Ah, the days of Access... It can look confusing, but stick with it. It's not that bad...

I'm learning about Data Warehousing/Data Cubes/Data Mining right now. Now, THAT is cool stuff. Predictive modeling. People who do A and B are most likely to do C.

BTW, I'm available for any and all Access/database-type questions. I'm not familiar with building a web site based on one, but for general concepts, I should be able to help.



There are a lot of strange people in the world. I should know; I'm three of them...

Well, tell me this then.

I need to create a page where users would be able to log in and view their billing information.

I created a Access database (I think) and then I think I need to create log-on page (which I did)

The only problem now that I am trying to figure out is Database Connection. I am reading DW manual so hopefully I will get somewhere this year LOL.

then after its all done I guess I could just export information to Access from Excell right? an I on the right track here?

MAX

Yeah, both exporting from Access to Excel and importing to Excel from Access is easily doable.

In Access, you'd probably want to set up a Macro that runs your query(s) and then exports it to an Excel Spreadsheet of a given name.

In Excel, you'd just go to Data>Get External Data>Create New Query. It'll ask you where you want to pull from and what fields you want to pull. Then it asks you where you want to put it/them. Pretty straightforward pointing/clicking.

Alternately, you could have Access send the query results to a flat file of some sort (like a text file) and have Excel pull from that, as an extra layer of data protection.

I can walk you through any of the methods, though (not being a programmer) I'm not sure which method you'd prefer for your purposes.

Hi

You might want to check out this file: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q260410.

Also the MSDN has great resource on ADO and DAO (which is still a very viable technology)
Keep in mind that many of the applications are really suited more for NT/MSIE environments
with or without FP extensions. Unix and NS are not on MS's guest list!

If you have Access 2000 or XP i'm sure you've check out DAP? Just look for the "pages" tab.

Good luck, sounds like fun. If you need any help on VBA/DAO/ADO (access to excel or vice versa, holler)
boy that's alot of acronyms

Here's an example from the url above, transfer data from Access to Excel. (i've done lots of development in this area but not to a web server, to a local web though (without the need for PWS).


Sub transferRecordset()

'Create a Recordset from all the records in the Orders table
Dim sNWind As String
Dim conn As New ADODB.Connection
Dim rs As ADODB.Recordset

sNWind = "C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb"
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & sNWind & ";"
conn.CursorLocation = adUseClient
Set rs = conn.Execute("Orders", , adCmdTable)

'Create a new workbook in Excel
Dim xlApp As Object
Dim xlBook As Object
Dim xlSheet As Object

Set xlApp = CreateObject("Excel.Application")
Set xlBook = xlApp.Workbooks.Add
Set xlSheet = xlBook.Worksheets(1)

'Transfer the data to Excel
xlSheet.Range("A1").CopyFromRecordset rs

'Save the Workbook and Quit Excel
xlBook.SaveAs "c:\My Documents\ADOExample.xls"
xlApp.Quit

'Close the connection
rs.Close
conn.Close

End Sub