Export records to excel columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi folks, first post on here but been browsing for a while and found this is
the most useful tool by a country mile for a novice like me to make an access
database. Thanks for all the help. I'm currently making a system for work to
handle all our service calls, stock control etc. I've ran into a problem that
I just cannot find an answer to. I need to output an excel file where all
records from a query are placed in separate columns, not rows. This is
necessary because I then have to review the file, convert it to text and
upload it via manufacturer's website. It can't be in any other format. The
query links parts to a repair, so there could be say five parts all linked to
the one repair (I have a stock items table where the stock location changes
to the service call no. once the part is claimed, then the parts are linked
to the repair reference). They have to follow each other in the columns of
the excel spreadsheet after the customer details. Is there a simple answer
I'm overlooking? I was thinking there might be a way to append the records to
a hidden table. Is this possible? Thanks in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Access Updating inventory levels 0
Writing SQL code to delete duplicate records 0
Help needed with adding a record in a subform 1
Stop Auto Fill 1
removing & adding stock to inventory database 1
Using an update query to update amount in stock automatically 1
Update Records In A Table 1

Back
Top