SQL/ VBA Data Manipulation
||I have an excel file with some data and I want to perform some operations on it and then produce an output...job can be easily done in SQL Server or VBA. I would prefer SQL Server but VBA is also ok.
||PHP, Software Architecture, Software Testing, Visual Basic for Apps
||Feb 20, 2012
||Feb 20, 2012Ended
Excel VBA Conversion To .Net
||We have an Excel Spreadsheet that has VBA programming in it. It is a data validator and formatter. It...with a form, and prompts you to choose what type of data file validation and conversion.
1. NextGen to...either operation spits out 3 files.
We want this Excel spreadsheet to be converted to a .Net v2 compliant
||Visual Basic, .NET, Excel, SQL, Visual Basic for Apps
||Feb 22, 2013
||Feb 22, 2013Ended
SQL SERVER AND VBA ACCESS FUNCTION
||...millions of records (900 million rows)
Write SQL function and VBA function to do the following:
1. Sort Ascending...Actual_Datetime
3. In the Geography_Name_From Column, copy the second value B3 to the Geography_Name_To Column...See example in the sample data attached.
When I run the function in SQL Server 2010, it should do the above
||SQL, Microsoft Access
||Aug 21, 2013
||Aug 21, 2013Ended
Excel addin to copy data from Excel to SQL DB
||...familiar with COM Excel addin programming in C# (not VBA)
The addin will sync data from Excel spreadsheet...spreadsheet to an SQL database (one way).
Detailed requirements located in an attached file.
||C# Programming, Software Architecture
||Nov 29, 2011
||Nov 29, 2011Ended
Excel VBA to VB/SQL
||Conversion of Excel VBA to VB/SQL. Have an excel VBA program and a excel database which we wish to convert...convert to a small networked Windows XP based VB/SQL system for up to 6 computers. Would like the ability...ability for several users to be able to enter data at the same time and be able to view the reports that
||Visual Basic, .NET, Script Install, Data Entry
||Dec 2, 2007
||Dec 2, 2007Ended
VB/VBA and SQL
||...The content in some of the files is caculated in excel via macroes before they are imported to access....to display the data in various ways. This does not have to be in Access. Some sort of SQL would be ok.... We already have MS SQL so this would be a preffered solution.The reporting and management should be
||PHP, Engineering, SQL, Software Architecture, Microsoft Access, Software Testing, Website Testing, MySQL, Visual Foxpro, Website Management, Web Hosting
||Dec 7, 2006
||Dec 7, 2006Ended
SQL SERVER AND VBA ACCESS FUNCTION - Rehire
||...I love your work and I need a similar code in SQL SERVER 2010 and MS Access.nnPlease see requirements...Sort by Rec_ID Ascendingn4. In Direction_01 Column, copy the D4 to Direction_02 Column E3, n5. D5 to E4,...again. See row 141. The value of row E141 must not copy to D140 because the equip_no is different. The processes
||SQL, Microsoft Access,
||Aug 26, 2013
||Aug 26, 2013Ended
Copy SQL Server Data
||...to make a copy of a database if both are on the server). What I need is to be able to copy a database...one source to another and either the source is a server file or the source is a file attached but being
||Visual Basic, .NET
||May 26, 2011
||May 26, 2011Ended
Excel VBA : lookup and copy data
* EXCEL VBA script
'wait 3 minutes for data to process
'select the 'Export search results o excel' link
( this code is not accurate)
||PHP, Project Management, Engineering, Software Architecture, Software Testing, MySQL
||Feb 23, 2010
||Feb 23, 2010Ended
control mouse with vba/excel
||...some help getting data into excel from another application. Would like to have excel/vba macro change focus...to select/copy data to paste into an Excel Worksheet. Then loop & do again, etc. The data in the other...select/copy it. The other application is not a Microsoft application. I can work with VBA/Excel OK bu...
||PHP, Visual Basic, Engineering, Software Architecture, Software Testing, MySQL
||Oct 9, 2004
||Oct 9, 2004Ended
Excel VBA: HTTP and Charts
||...exploratory project to download data and chart setting from a web-server.
Please consider bidding...experience of the needed VBA techniques.
**VBA Excel: HTTP Downloads and...a chart whose specification and data are downloaded from a web-server.
The user is given a workbook
||Windows Desktop, Software Architecture
||Nov 5, 2012
||Nov 5, 2012Ended
||...a lot of data and some columns are calcs (a1:cc12000).
Need someone to create a few VBA macros/forms...macros/forms that will sort this data and output into a few variations into? new worksheet in same file as well...well as different excel file.
Addendum (8/10/08) -
Specifically on sheet data! for any row where
||PHP, Engineering, Software Architecture, Software Testing, MySQL
||Aug 8, 2008
||Aug 8, 2008Ended
VBA Excel, MsAccess, SQL Server Articles...
||...Original (tested against CopyScape Database)
on VBA Excel, MSAccess.
600 Words each minimum. Grammar
||Copywriting, Internet Marketing, Windows Desktop
||Aug 17, 2007
||Aug 17, 2007Ended
VBA Excel Macro
||...create a folder tree and copy files according to an excel list of paths.
- a tree structure...and files and the path to this structure.
- an excel sheet listing all the files of the tree structures...for instance: c:myfolderpathfile1.rtf
The excel contain several columns. Two are important in this
||PHP, Perl, Java, Visual Basic, Excel
||May 17, 2009
||May 17, 2009Ended
VBA in excel
||...individualized invoices for a retail sales company. The input data will consist of a customer database file which contains...orders data file with customer ordering information (item number and amount); and a products data file...information and will be captured and saved to an Excel databases that will be displayed at user request
||Visual Basic, Excel
||Apr 5, 2014
||Apr 5, 2014Ended
Excel VBA Project
||We need a VBA pro to write a fairly simple macro for us. It will basically open an external spreadsheet...spreadsheet and copy a range of cells (actual values, not formulas) into the current spreadsheet.
It will...this for (5) separate spreadsheets. The retrieved data will be stacked on the current spreadsheet and a
||PHP, Engineering, Software Architecture, Software Testing, Website Testing, MySQL, Website Management, Web Hosting
||Feb 2, 2005
||Feb 2, 2005Ended
Excel Web Extract + VBA Data Processing + MS SQL
I need data extracted from the web and inserted into a yet unmade MS SQL Server database. The
||Visual Basic, Data Processing
||Jul 8, 2007
||Jul 8, 2007Ended
Excel VBA coder required
I want a Excel VBA coder to create a copy of the spreadsheet attached. You will need to use a...the text as it is.
You will need to create vba code so that users can customize it with their own...coming up. It must work on all versions of Excel
All vba code must be documented very well and in
||PHP, Windows Desktop, Engineering, Software Architecture, Software Testing, Microsoft, MySQL, Visual Basic for Apps
||Oct 15, 2008
||Oct 15, 2008Ended
Excel Spreadsheet - Insert/Update SQL Server Not dBase
||...have an Excel Spreadsheet which reads cells, then checks a foxpro dBase database if the data exists and...REPLACED with a SQL Server 2005 instance and so the VBA must be adjusted to read the SQL Server Database.
The changed VBA must therefor:
1) Setup the Connection to the SQL Server
2) Check is the reco...
||Visual Basic, .NET
||Mar 29, 2011
||Mar 29, 2011Ended
||...Number. (See worksheet 'TblAllocations' for sample data) For example We know that it takes 3 yards of Crystalfex...are 300+ lines in total…see spreadsheet for sample data) 2. Create another new Worksheet “Allocated?? that...need to fulfil each shipment and when (see example data for the exact format.) I have filled up Sheets “Allocations
||Jun 1, 2006
||Jun 1, 2006Ended