Excel data to Access

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi,
I have file with data being modyfied by users from time to time.
In Excel it looks like:
name month (other collumns)
1 2 3 4 5 6
......
Student Michael 234 34 2 67 65 34....

I need ths data into acces like

student Michael 1 234
student Michael 2 34

I cant use Transponation as I need data from every second line in
Excel.

Is teher any good and efficient solution for making such a forms ?

regards
Peter

.

Relevant Pages

  • RE: Access 2003, import data from a txt file
    ... I use the Excel import external data tool to convert the txt file to Excel. ... > How do I convert them into collumns so that I can import them to access? ... > Nature of Business: Importer ...
    (microsoft.public.access.externaldata)
  • Getting specific data from a word document into an excel sheet
    ... I am trying to import a table of data from another programme into excel to ... document is words and symbols but I need to highlight the two collumns of ... real difficulty doing this as when I try to highlight the collumn and drag ... Microsoft Office Word 2003 ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Getting specific data from a word document into an excel sheet
    ... > document is words and symbols but I need to highlight the two collumns of ... > numbers only and somehow get them into individual cells in excel. ... > real difficulty doing this as when I try to highlight the collumn and drag ... > Microsoft Office Word 2003 ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Getting specific data from a word document into an excel sheet
    ... > document is words and symbols but I need to highlight the two collumns of ... > numbers only and somehow get them into individual cells in excel. ... > real difficulty doing this as when I try to highlight the collumn and drag ... > Microsoft Office Word 2003 ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Getting specific data from a word document into an excel sheet
    ... >> I am trying to import a table of data from another programme into excel to ... >> document is words and symbols but I need to highlight the two collumns of ... >> numbers only and somehow get them into individual cells in excel. ... >> real difficulty doing this as when I try to highlight the collumn and drag ...
    (microsoft.public.excel.worksheet.functions)