Summary: Hi Many times, I have converted PDF file to Excel table with saving as text and opening in Excel. I have a table with 7 columns on paper now that got ...
Summary: Hi all I have two databases in works 2000 that I want to convert to access 97. The first has 16,000 + entries and after copying to excel, the conversi...
Summary: Two different files in Excel 2000 Do you mean different "sheets" or "workbooks"? Either way, you can't use conditional formatting. You will get the er...
Summary: I want to be able to export a table in access to excel and if one of the values is 0 or less then a certain number i want the background color of the ...
Summary: You may be out of luck trying to access the file directly as it's propriatry. I've tried this numerous times and I think it's some kind of ingress mod...
Summary: Thanks. I've tried this and also setting each number with the Int(99) and Fix(99) (integer and fixed number format) and I always get the "type mismat...
Summary: i'm trying to figure out the code to add an import-from-excel option that will place data in its correct fields as seen in the following pic of the ac...
Summary: I am looking for help and info to convert an Excel Spreadsheet to an Access Database (MDB) Any help or guidance would be great! Thanks in advance for ...
Summary: You could try it in Access VBA with something like: Sub DoExcel() Dim appExcel As Excel.Application Dim wb As Excel.Workbook Dim sh As Excel.Worksheet...
Summary: I am having trouble importing excel spreadsheets into Access 2000. When I select the file to import there is a message in the status bar saying "Impor...
Summary: I loose some data when converting from text..even when I change the format.. example size column in excel worksheet is formated as text.. but when con...
Summary: I need to have interactive reporting system, i tried to use crystal reports but the system can not give me interactive reports. when you need another ...
Summary: Hi I am trying to spool the output of 3 sql queries into different sheets of the same excel file. Like Query 1 result in sheet 1 of report.xls Quer...
Summary: I need to find a solution that will allow me to take each record from a database (Access most likely) and allow me to generate individual PDF's for ea...
Summary: My DVD collection is getting ridiculously huge and I want to make an inventory database for it so I can keep track of it all. I'd like to make it comp...
Summary: sorry I don't have excel installed on this machine so cannot remember the exact syntax but one of the "LOOKUPW formuluae should be able to do what you...
Summary: I use Access to populate the Word client header (mail merge) and save it as a .....doc. The Excel Workbook is embedded into the ...doc. Each month m...
Summary: Hi all, Can someone please explain to me if it is possbile (and if so how) to pass values from one Excel workbook to another (located in a different n...
Summary: Hi, I need some help on Excel & Word documents, basically I need to create a macro so that when I run it it will send me to a Word document. So if I c...
Summary: I would like to pipe the results of all the applications on my Citrix farm to an excel file which is fine but I would also like that excel file to upd...
Summary: Hello all. In my office we have a spreadsheet which we use to keep track of prices which we are quoted. This system seems to work rather well, but I'm...
Summary: What program are you using? If it's Excel, you should post in the Office Software Forum. This is the Database Forum. "So won’t you give this man h...
Summary: Hi, I am looking to forecast fraud levels for personal loans over the next twelve months using excel. I have data of losses occurred in th epast twelv...
Summary: Hello Everyone, I am new to this forum, so thank you for all of your assistance. Here is what I am tring to do. I have created a worksheet in excel '0...
Summary: Hey guys, its me again. This time I have a question relating to the following problem: I have a macro recorded the sort and set an excel file in a bet...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
