database information

[Buggins]

I am using FP 2003. I have set up a database using FP the decided to add
information that was on excel page. how would I send the information from
excel (or access) to the database so it shows up in a search.

 

[Wayne-I-M]

Hi

The main problem you would have is in maintaining any relationships - well
it's not a "real" problem it is just that if you google this, most of the
answer will remove the realtionships and basically "mess up" your DB. Mind
you in you're just using the access DB to store a sinlge table (eg. a list of
passwords, or dates, etc) then this will not be a problem.

You can use something like

DoCmd.TransferDatabase acExport, "Microsoft Access", "Path to DB.mdb",
acTable, "TableA", "TableA", structureonly:=False
DoCmd.TransferDatabase acExport, "Microsoft Access", "Path to DB.mdb",
acTable, "TableB", "TableB", structureonly:=False
DoCmd.TransferDatabase acExport, "Microsoft Access", "Path to DB.mdb",
acTable, "TableC", "TableC", structureonly:=False

There is not much difference in exporting and importing (there are "some" -
just not many) so have a look at an answer I gave a while ago and feel free
to copy the code if you want. You will need to amend it to "send out" rather
than "bring in" but thats quite simple.

http://groups.google.com/group/micr...roup:microsoft.public.access#786781a92a2adf02

If you need more information you could post a question in the access area as
this is not really an FP problem

Good luck with your project

 

[Buggins]

I thought there would be something simpler. let me reask the question. I do
have 1 table with 8 fields right now. I want to create a new database in FP
that will have all this information on it. I think I have about 10k records

 

[Thomas A. Rowe]

You would need to open the Databases in Access and copy the table to the other database, etc.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
http://www.Ecom-Data.com
==============================================

 

[Buggins]

when I open the databases, I have 1 that I was using, 1 table in it called
results with nothing in it. the other that I am wanting to add has 1 table
called table1. I added table1 to original db and now my results page comes up
with some of the information but not all. Is there a tutorial on intigrating
an access db?

 

[Thomas A. Rowe]

You are not so much integrating, as you need to learn ASP/VBScript to access and display the content
of the two tables. Start by looking at the samples on http://www.asp101.com


--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
http://www.Ecom-Data.com
==============================================