By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,994 Members | 2,073 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,994 IT Pros & Developers. It's quick & easy.

Append records from floppy

P: n/a
I have a database in ACCESS 97 and i have a routine that copies the
tables to a database onto a floppy.

What i would like is a routine to transfer the data from the floppy
into the tables in a database on a laptop. ( i can not replace all the
tables because in those tables are the records from the laptop
itself). Is there a way to append the records from the floppy into
the database from the laptop????
If so, can you help me because all the rest of the program is done,
just this append routine is giving me a hard time!!!
Anyone, anywhere, anyhow, anyway TX TX TX
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Peter D wrote:
I have a database in ACCESS 97 and i have a routine that copies the
tables to a database onto a floppy.

What i would like is a routine to transfer the data from the floppy
into the tables in a database on a laptop. ( i can not replace all the
tables because in those tables are the records from the laptop
itself). Is there a way to append the records from the floppy into
the database from the laptop????
If so, can you help me because all the rest of the program is done,
just this append routine is giving me a hard time!!!
Anyone, anywhere, anyhow, anyway TX TX TX


Could you create a link to the database on the floppy, create a couple
of queries to do the appends, and run with that?

One can link to Excel spreadsheets and text TXT files and make them
tables.

In a perfect world you might want a form that creates a link to the data
on the floppy, run the append queries, and delete the links. You might
start by experimenting with
DoCmd.RunCommand acCmdLinkTables
to link the table. Using a tabledef you should be able to delete it.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.