Recent content by BenMason

  1. B

    Import Excel CSV Specific Cells to MS Access Table

    Just one row in Access. Ben
  2. B

    Import Excel CSV Specific Cells to MS Access Table

    Ah, I see where I need to explain more. Yes, Gasman, the data in ExcelCVS looks like your column 2. I would like to import it into Access so that it looks like Column1 Column2 JPWestfield 8/1/2019 Ben
  3. B

    Import Excel CSV Specific Cells to MS Access Table

    Hello the DBguy, I was thinking about that. But the Excel CSV data is in rows. The append in Access inserts into columns. I'm trying to get the row data from Excel into columns in Access. Like: "JPWestfield" is in row 1 column (B1) in Excel CSV "8/1/2019" is in row 2 column (B2) Excel CSV I...
  4. B

    Import Excel CSV Specific Cells to MS Access Table

    I have a CSV delimited file with row data that I want to transfer to MS Access columns. MS Access is already open; I have a button on Access form to import Excel to the table. For instance, In the CSV file cell b1 and b2 have this data: JPWestfield 8/1/2019 Customer and date are columns in...
  5. B

    Insert a blank row in Excel after Access export to Excel

    I have created an Excel Template. In Access I export data from a query to the Excel Template which works fine and it opens the Excel template so I can see the data that it exported. With the Excel template still open, how do I, with VBA, insert a blank row when column A date changes? Example in...
  6. B

    How to create a temp table from concatenated fields that vary in length

    You are right. The Parts table is not normalized. I'm trying to create a temp table but need to split the customer and PN and then write to the temp table. The splitting is where I am stopped. In the meantime I am creating a normalized CPN table that has the splits but it's very manual. Then...
  7. B

    How to create a temp table from concatenated fields that vary in length

    Thanks. I'm looking up the split() function. Ben
  8. B

    How to create a temp table from concatenated fields that vary in length

    Thanks for the function. I copied it to my functions module. But then I am lost. I tried to create a query using it and received #error in the field. Here's the query: MyField1: fnSplit(1,[Customer],"/") Ben
  9. B

    How to create a temp table from concatenated fields that vary in length

    I have a parts table. In it there are two fields that have string info (Customer and CPN). For instance: Parts Table Example: PartNo Customer CPN 1678 Yen/Stick/Pearson Yen: 2321*Stick: 52344J/45*Pearson: Hy45 1679 Carson Cy8911 1680 1681 Harry's In the example...
Top Bottom