Thanks a Ton.... SAM
----- Original Message ---- From: Paul Herring <[EMAIL PROTECTED]> To: [email protected] Sent: Saturday, October 27, 2007 2:10:33 AM Subject: Re: [c-prog] Hi On 10/26/07, Brett McCoy <[EMAIL PROTECTED] com> wrote: > On 10/26/07, learning_basic <learning_basic@ yahoo.com> 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 __________________________________________________ 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]
