On 10/26/07, learning_basic <[EMAIL PROTECTED]> wrote:
> Hi i am SAM new to this community, well i have some problem if u guyz
> & Galz can advice than i will be great full to u problem scenerio is
>
> Question:-The Excel spreadsheet contains data in a specific format.
> The data needs to be imported into the Access database using any
> language
> Excel file contains sales information broken down by year, region,
> product and country. The database needs sales total by country, region
> and year.
>
> Well i wana know how i should progress in it and which language u think
> would be better to go with
I don't see that you need any language, just decide on an intermediate
file format (comma-delimited, for example) that both applications can
handle and export from Excel and import into Access. At the very
least, you can probably extract data directly from Excel into Access
using Access's VisualBasic scripting capabilities.
-- Brett
------------------------------------------------------------
"In the rhythm of music a secret is hidden;
If I were to divulge it, it would overturn the world."
-- Jelaleddin Rumi
