-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
export problems
-
M
Problem exporting time formatted data from Access 2010 to Excel 2010
Hi all. I'm having a problem exporting an Access 2010 query to Excel. The Access query contains a number of text and numeric fields which export with no issues. However, one of the fields is in a time format ([nn]:ss) which, when exported to Excel, fails to transfer the values. The database...- Morogth
- Thread
- access 2010 excel 2010 export from access export problems time format
- Replies: 0
- Forum: Excel Questions
-
M
User Parameter Query (Acess 2003) to Word Template
Hi, i am struggling with how to effectively 'export' the results of a query into a word template, where the query prompts the user for a query parameter. I have set up the word template (.doc) and added in bookmarks to send the query data too but I cannot seem to get my head round how to...- mick5003
- Thread
- access 2003 export problems word
- Replies: 3
- Forum: Microsoft Access
-
R
ACCESS TO EXCEL EXPORTATION coming through in a random order (Office 10)
I have exported some data from Access to Excel (2010) and once exported to access the data is in a different order from when it was in the query. The data is all under the correct headers but each column is randomly ordered. The query is in the following order (by fieldnames) CompanyName...- R_McCallan
- Thread
- access excel export problems exportation randomised fields
- Replies: 5
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Dynamic cell and sorting
- Started by Polanskiman
- Replies: 31
So here is the deal. I need that cell in E4 to be dynamic because the "Description" column on the Excel table is supposed to be sortable. By... -
How do I get combobox to get a cell number then link it to a selection from a checkbox in Excel?
- Started by Ayugma
- Replies: 31
I have no idea how to really implement this. So I have 5 checkboxes, all of which are parts to a machine. So, a user will be able to select as... -
VBA code works on works desktop but not on my own laptop
- Started by Monojono
- Replies: 30
Hello Readers and hopefully problem solvers, I have a large amount of coding across my workbook that works fine on my works desktop. However, on... -
Formulas referencing Pay Dates in year
- Started by rishijain11
- Replies: 27
Hi, I'm trying to build out this excel file to keep track of my finances. I could use some help with several formulas revolving around the pay... -
Sorting key
- Started by dpaton05
- Replies: 25
When you are sorting using range.sort method, one of the parameters is Key. If I want to sort by column A, with the header being in row 3 and the... -
Copy Range of Cells And Paste Until Last Row
- Started by Unexpc
- Replies: 21
Hi guys i have a page in range A41:H74 and i want copy this page and paste until last row of excel sheet. does any vba code to do this?