Filling unknown number of rows between static rows with access

Hello

I am trying to centralize codes in multiple spreadsheets using access tables. My first row in the excel sheet will have headers and my Last row in the excel sheet will have totals. What I would like to do is fill in between the header and totals row with the entire population of the codes table I have created in Access. The number of entries will be updated in the database. I was wondering if there was a way to make the header and totals row accordian around this query.

Thank you
reece

Yes, if you use Data->Import External Data->New Database Query, and set your properties to insert rows.

Ah, Thank you very much

Do you need help with it at all? I wasn't sure how much info to provide since you are working from access and so presumably have some familiarity with queries. If so, just provide a bit of detail and I will try to walk you through it.

Also, a search for MSQuery may be beneficial.

That was all I needed. I am familiar with writing queries.

Thank you for the hlep.

reece