reformatting a multi-tab spreadsheet and access 2003

5 pts.
Tags:
Access 2003
Excel 2003
Excel worksheets
Record Format Level Identifier
Hi,

   I have an instance where I have an Excl 2003 spreadsheet and need to reformat it into a single record format using the data from each of the tabs but I also need to put additional data into the new record. Here is another twist I want to be able to trigger this from my access 2003 switchboard an upload the new formatted record into my database. Please Help

Thanks

Carmen

 

  



Software/Hardware used:
office 2003
ASKED: November 24, 2010  2:41 PM
UPDATED: December 1, 2010  1:42 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Chippy088
    This is a task I've done many times, and never the same way each time. It is made harder by the different ways data is entered and used, (calculations etc.) The main problem is you need to understand the interaction between each sheet in the whole workbook. As you haven't given any indication of what sort of data (and their relationships,) is in the workbook sheets, I can only give you a general idea. I would suggest that you start by copying all the column headings of each sheet, to a check list, then work out which ones are the result of calculations, and whether they are then used in another sheet. This is no easy task, but you really don't want to take unneeded columns across. Particular attention needs to be taken with linking data from different sheets, using a primary key, if this doesn't work, then you will need to use more than 1 table in the new database you create. You then need to create the new database with the characteristics of the data cells set up. I create a duplicate spreadsheet, and copy real data into it, from the live workbook, to check the results when it is entered into the new DB. Without more information, I can only suggest guide lines for you to try. As I said before, each time I've done this it has been different. Good luck, post more observations if you need further assistance.
    4,625 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following