exported

I have a report that I have exported as an Excel file (.xlsx) from Insightly. I am trying to see if the date exported (Col C) is less than or greater than the current date =Today() in (E1). I am using the formula =if(exporteddate(D2)<currentdate($E$1),"less","greater")...

Can journal detail from 10 divisions in excel exceeding 100,000 lines each be exported into access, so that all data can be viewed in one database at one time instead of opening 10 different worksheets?

Hi everyone - There is only a ExportWithFormatting action in Access and not "without", which limits the amount of records that is truly exported (65,000 records). I have a table and it's 300,000 records that need to be exported to excel using a Macro. Since the action does not exist, I need to...

I'm getting an error when I open Excel files that have been exported from Access in Office 365. In researching this I see that part of the issue may be range names that are coming over in the export. I have NOT checked the box to export formatting. How can I prevent this data (which is being...

Hello, I have a table that it's exported from another software. it's something like this: https://docs.google.com/<wbr>spreadsheets/d/13A-<wbr>iAbq0X18G9vBmou5KqDcaF-u_<wbr>jK7vxOoL1HY5YNE/edit?usp=<wbr>sharing and it repeats at each diferent No_ And i need it this way or similar...

RE: VBA Code to hide rows, if column value is a certain value, and then export to new workbook Hi, In a sheet/tab named “Reporting_Interface” I have a drop down box that has a list of the 5 tab names within my workbook. Each of these 5 tabs have different data displayed in a very similar...

Hello, This is the first time I am posting. I am working on automating a report with different queries exported from Access into an existing Excel workbook. Each query is exported into a new tab with the query's name (i.e. Shipped, Received, CDR, CurrentShipped). I have a main sheet that has...

I have exported a worksheet from a SharePoint library, it has the file name and the hyperlink to the SharePoint location already. I am attempting to match these to another link that has the same list of file names so I used the command =HYPERLINK(VLOOKUP(G2,A:A,1,FALSE),G2) G2 is the file...

We have a specific user that is exporting to Excel and the output is in comma delimited format. All other users receive their exported spreadsheet with their data in separate columns (Text to columns is done systematically). Any thoughts as to why this user would receive their exported data in...