Thanks
----- Original Message ---- From: Brett McCoy <[EMAIL PROTECTED]> To: [email protected] Sent: Saturday, October 27, 2007 12:48:25 AM Subject: Re: [c-prog] Hi On 10/26/07, learning_basic <learning_basic@ yahoo.com> 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 __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed]
