On 10/26/07, Brett McCoy <[EMAIL PROTECTED]> wrote: > On 10/26/07, learning_basic <[EMAIL PROTECTED]> wrote: [...] > > Question:-The Excel spreadsheet contains data in a specific format. > > The data needs to be imported into the Access database using any > > language [...] > 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.
A common language the two have is SQL - connect to both, extract from one using SQL, (optionally munge, then) import to the other using SQL. Totally off topic, I'd perhaps suggest VBS for this rather than any C(++) implementation, having done something similar at work (which I'm happy to tell everyone that I'm leaving) - collating data from one source and importing to another. -- PJH "Statistics are like a bikini. What they reveal is suggestive, but what they conceal is vital" -- Aaron Levenstein
