Summary: Hi, I would really appreciate if someone could help me with the following problem: Here is what I have: Two different files in Excel 2000; Each file c...
Summary: If I'm understanding you correctly, and if you have Access, you could perform the task in that. AND........ Import your already existing excel spread...
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: 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: 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 am trying to get a weekly schedule on a different worksheet from a monthly spreedsheet. The Montly has all name on the employees name the next colu...
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...
Summary: Hi, I am trying to figure out which function that I need to use. I essentially have two columns; Column A consists of account #s and Column B consists...
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: Hi Does anyone have a code for searching for 4-5 keywords within columns in a single excel worksheet then returning the list of matching rows, ordere...
Summary: Ok I am kind of new to this site and have been trying to figure this out for a while... I need to sort a worksheet in a workbook by the acount number ...
Summary: I have a database in SQL Server that already has tables and data in it. I also have and Excel 97/2000 workbook which has sheets named corresponding to...
Summary: Hey Everyone, I'm currently trying to setup an online store, my wholesaler provides all their product info via .CSV file. The file from my wholsaler ...
Summary: Hello, I am Software Development Intern at a small company. We run Microsoft SQL Server 2000 on Win2k. One of our database tables was recently destroy...
Summary: Hi everyone, I have to run a conversion on multiple tables to change the data in one column on each table. I am happy to run this separately for each...
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: May I ask if any sql statement to compare date with today and give the result on each record? e.g table Date Name 8/1/2008 Tom 27/12/2008 Ann 2...
Summary: I am trying to export a single record from an MS Access 2000 database to an html template. Is there a way to do this without having to do a lot of pro...
Summary: Hi, We have just installed visual studio 2008 which includes sql server compact edition 3.5. We want to export an sql server 2000 based database to ne...
Summary: I had MS Access 2.0 for a long time. Then I got MS Access 2000. There's one thing that bugs me about the newer version: when moving between a form's f...
Summary: I have a large number of sheets (120) in a single Excel workbook file. I can import each sheet individually into an Access table using the import wiza...
Summary: Dear all, I have a problem with sql function: I want to change Amount column to Words, senirio is like this: i have a 2 column, 1 has name and 2 has a...
![[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
