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.

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/micro...6781a92a2adf02

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


--
Wayne
Manchester, England.



"Buggins" wrote:

> 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.

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
on that table and cant enter them into fp database submission page. how would
i send the 1 table to FP database. a new database.

"Wayne-I-M" wrote:

> 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/micro...6781a92a2adf02
>
> 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
>
>
> --
> Wayne
> Manchester, England.
>
>
>
> "Buggins" wrote:
>
> > 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.

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" <(E-Mail Removed)> wrote in message
news:2D6E67A0-6758-4C6F-A62B-(E-Mail Removed)...
>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
> on that table and cant enter them into fp database submission page. how would
> i send the 1 table to FP database. a new database.
>
> "Wayne-I-M" wrote:
>
>> 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/micro...6781a92a2adf02
>>
>> 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
>>
>>
>> --
>> Wayne
>> Manchester, England.
>>
>>
>>
>> "Buggins" wrote:
>>
>> > 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.

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" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:2D6E67A0-6758-4C6F-A62B-(E-Mail Removed)...
> >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
> > on that table and cant enter them into fp database submission page. how would
> > i send the 1 table to FP database. a new database.
> >
> > "Wayne-I-M" wrote:
> >
> >> 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/micro...6781a92a2adf02
> >>
> >> 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
> >>
> >>
> >> --
> >> Wayne
> >> Manchester, England.
> >>
> >>
> >>
> >> "Buggins" wrote:
> >>
> >> > 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.
>
>
>

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
==============================================


"Buggins" <(E-Mail Removed)> wrote in message
news:E167C5BA-A06A-49FD-A92B-(E-Mail Removed)...
> 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" wrote:
>
>> 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" <(E-Mail Removed)> wrote in message
>> news:2D6E67A0-6758-4C6F-A62B-(E-Mail Removed)...
>> >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
>> > on that table and cant enter them into fp database submission page. how would
>> > i send the 1 table to FP database. a new database.
>> >
>> > "Wayne-I-M" wrote:
>> >
>> >> 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/micro...6781a92a2adf02
>> >>
>> >> 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
>> >>
>> >>
>> >> --
>> >> Wayne
>> >> Manchester, England.
>> >>
>> >>
>> >>
>> >> "Buggins" wrote:
>> >>
>> >> > 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.
>>
>>
>>