Import Specification and split DB's

J

Jean

Hi,

I have a database that is split into a front-end and back-
end. I have also created a Import Specification (with the
Import Wizard) on the back-end.

Now, I have a form that uses code to import data from a
file into a table on the back-end. This code uses the
Import Specification on the back-end. Is there a way of
creating an Import Specification on the front-end, so that
I can use this specification on a front-end form rather?

This is what I am trying to do: I want to create an Import
Specification on the front-end using the Import Wizard. I
specify the import specification details in "Advanced.."
of the Wizard. Then in Step 3 of Import Wizard the linked
tables do not appear under the drop-down list of "Import
to existing table".

Can I simplify this in anyway by importing data to the
table on the back-end?

Also, Microsoft speaks of setting up a schema.ini file to
detail the import specification. How do I do this?

Thanks for any advice!

Regards,

Jean
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
Error Saving Import/Export Spec 1
Invalid Argument Different for FE/BE 13
Annoying Invalid path message from Link Specification 2
Saving Import Errors 0
HTML Import not parsing properly when using VB or macro 1
Import Specs Changed "Magically" in Midst of Loading Sequence 3
import filename error 1

Top