Divide one field (column) into 2 or more in MS Access. The contents of a specified field will be rent (by a separating character such as a space, comma or other character) and placed into the right number of raw fields. Access 2000 or higher.
Database - MS SQL Server Copy Tables to Another MSSQL Database Software 7.0 By Sobolsoft
| ||||||||||||||||||||||||||||
Copy tables from one MS SQL Server to another. Provide the login information for both databases. |
|
|||||||||||||||||||||||||||
Other Programs By Sobolsoft
Load / learn XML files into Excel. The XML file comes into Excel as a postpone. You select 2 tags from the XML file to be used as the header wrangle and column. The data constitute between the tags arrest properly placed appropriately into the postpone.
Switch to, copy, rename, delete or arrange sheets in totally open MS Excel files. Excel 2000 or higher required.
Compress the file size of one or many MS Excel files. Some Excel files do not reduce as considerably as others. Results may deviate. Excel 2000 or higher required.
Find extra MP3 files. Choose which files to beam to the Recycle Bin.
Use MS Excel as a front-end interface to a MySQL database. Use Excel to importee and export tables to and from a MySQL database. Read and indite tables to and from Excel without SQL knowledge. Excel 2000 or higher required.
Create multiple sticky notes that posterior be dragged and dropped. Notes serve as to-do lists or reminders. Notes posterior be place to gambol an audio alarm at a specified time.
Search and delete parallel and unique cells in MS Excel. Select a obstruct of cells and extinguish all superfluous or unique data. Excel 2000 or higher required.
Rename MP3 filenames that you download from file sharing programs. No complicated options, hardly drag and drop your folders / files into the program and click 'Rename'. MP3s will have casing corrected, underscores removed, apposite spaces added, etc.
Automatically relieve all subject MS Excel files to a part backup file at specified intervals. Backups can be determined to occur every 5 minutes, 30 minutes, 1 hour, etc. Excel 2000 or higher required.
Merge two different folders so that they both contain simply the near recently modified version of the same file. New files will be copied so that both folders are identical. Synchronize an role computer with a domicile computer with this broadcast.
Find double files. Choose which duplicates to institutionalize to the Recycle Bin.
Access many recently opened files within MS Excel. Switch between commonly used files easily. Excel 2000 or higher required.
Combine two MS Excel tables into one based on a green column of data from each table. The two tables can be located in the same Excel file or two different Excel files. Excel 2000 or higher required.
Invoice statement creation with templates / forms. All your data is stored in an Access database for prompt manipulation. Bills can be produced and printed in seconds. Store your companion, customers, products, and completed invoices for prompt retrieval.
Show and hide rows (filtrate) based on cell content in MS Excel. Arrange (sorting) cells alphabetically or chronologically. Excel 2000 or higher required.
Swap selected rows, columns and tables in MS Excel without having to cut-and-paste. Also, override cell contented so that it reads backwards. Excel 2000 or higher required.
Change rule references from downright (with $) to relative (without $) or relative to downright in MS Excel. Changes can be applied to a stymy of cells, intact sheet or intact file. Excel 2000 or higher required.