Käynnissä

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.

Taidot: tietojenkäsittely, Microsoft Access, Visual Basic

Näytä lisää: 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

Tietoa työnantajasta:
( 0 arvostelua ) United States

Projektin tunnus: #15474634

Myönnetty käyttäjälle:

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 Lisää

155 $ USD 5 päivässä
(84 arvostelua)
6.8

8 freelancers are bidding on average $179 for this job

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 Lisää

164 $ USD 3 päivässä
(199 arvostelua)
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 Lisää

150 $ USD 2 päivässä
(147 arvostelua)
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 Lisää

264 $ USD 3 päivässä
(88 arvostelua)
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 Lisää

175 $ USD 2 päivässä
(61 arvostelua)
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 Lisää

175 $ USD 3 päivässä
(50 arvostelua)
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 Lisää

175 $ USD 3 päivässä
(10 arvostelua)
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 päivässä
(19 arvostelua)
3.6