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
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...
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...
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...
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...
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
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...