Completed

convert a MS Access table from mostly columns to mostly rows

We have a Microsoft Access (2007) table that has perhaps 50 columns, and ~1500 rows of information. But I would like to convert (and move the underlying data) most of the columns to rows. Much of the column information repeats to some extent. I would like someone to write what I'm guessing is some simple code to do a 1-time conversion of the table. The table has confidential information that I will not be providing, but I can do a mock-up of the table with some fake column headings, and would ask you to write and provide the code to me (and instructions) so I could execute it for the conversion.

Квалификация: Обработка данных, Microsoft Access, Visual Basic

Показать больше access query criteria last record, access import errors type conversion failure, query most recent date access 2010, access query most recent record, access 2010 max function, access query max date, access query most recent date criteria, access query most recent date, convert ms access file executable, convert ms access exe program, convert ms access executable file, convert ms access executable, convert ms access exe, convert ms access db standalone, convert ms access database work web server service, convert ms access database stand application, convert ms access database standalone software, convert ms access database program, convert ms access database exe, convert ms access database exe

О работодателе:
( 0 отзыв(-а, -ов) ) United States

ID проекта: #15474634

Поручен:

someka

Hello. First I will work with your dummy data, create the necessary code, test it on sample access database then deliver you the code. You will be able to run it on your database. Relevant Skills and Experience Access Больше

$155 USD за 5 дней(-я)
(84 отзывов(-а))
6.8

8 фрилансеров(-а) в среднем готовы выполнить эту работу за $179

branislavm

Hi! What we need here is a code that will load data from the table and write to new data. This is called "transposing data". It will help if you can send a mockup, with just a few rows of dummy data. Relevant Skills a Больше

$164 USD за 3 дней(-я)
(199 отзывов(-а))
6.9
sumon355

As an expert in ms access related works, i am very much interested to do this work. Looking forward to have a positive response from you. Thanks Relevant Skills and Experience vba Proposed Milestones $80 U Больше

$150 USD за 2 дней(-я)
(147 отзывов(-а))
6.6
ponnarasiBabu

I read your requirements, We have a Microsoft Access (2007) table that has perhaps 50 columns, and ~1500 rows of information. But I would like to convert (and move the underlying data) most of the columns to rows. M Больше

$264 USD за 3 дней(-я)
(88 отзывов(-а))
6.3
kolosibalint

Hi there, Without seeing the data or the table itself it's difficult to tell whether an SQL or a VBA script would me more sufficient solution to transpose your data, but I will propose the better one Relevant Skills Больше

$175 USD за 2 дней(-я)
(61 отзывов(-а))
5.6
vsprybhanu

Hi, I can create a macro to convert table data into new table according to specific condition. No matter how many records are there. Macro will detect rows and column numbers. Relevant Skills and Experience Experienc Больше

$175 USD за 3 дней(-я)
(50 отзывов(-а))
5.1
gumadevi89

I am an access and VBA expert who can help to transpose the data basis your requirements. 100 % accuracy and effective solution guaranteed. Relevant Skills and Experience I have over 7 years of experience in developin Больше

$175 USD за 3 дней(-я)
(10 отзывов(-а))
4.1
contactvidura

Dear sir, I can implement a converter in JAVA. Would like to discuss.. Thanks Relevant Skills and Experience I have implemented Derby to MySQL convertor before.. Proposed Milestones $175 USD - Milestone

$175 USD за 3 дней(-я)
(19 отзывов(-а))
3.6