Multiple Import Schema?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tirelle - 24 Dec 2007 01:02 GMT

I am working on an application in which I need to import data from excel
files. I am working with approximately 4 different strucures of data in the
excel files. I am new to using schemas but unerstand the concept. However,
as i understand you can only have 1 schema file and it must be in directory
where data is and must be named schema. Is there a workaround or another way
to import data programmatically from excel?

Thank You

Reply to this Message

Jeanette Cunningham - 24 Dec 2007 09:23 GMT

Hi Tirelle,
If you are doing the import using VBA code, look into
DoCmd.TransferSpreadsheet

this website http://www.rogersaccesslibrary.com/TableOfContents3.asp#I
has sample databases for importing spreadsheets

Jeanette Cunningham

>I am working on an application in which I need to import data from excel
> files. I am working with approximately 4 different strucures of data in
[quoted text clipped - 8 lines]
>
> Thank You

Reply to this Message

Tirelle - 24 Dec 2007 14:38 GMT

Thanks Jeanette!!! I will.
Alos, 2 of the files are text files.

> Hi Tirelle,
> If you are doing the import using VBA code, look into
[quoted text clipped - 17 lines]
> >
> > Thank You

Reply to this Message

Dale Fye - 27 Dec 2007 20:45 GMT

Checkout the Help on TransferText method as well.

Dale

Signature

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

> Thanks Jeanette!!! I will.
> Alos, 2 of the files are text files.
[quoted text clipped - 20 lines]
> > >
> > > Thank You

Reply to this Message