Is there a way to copy data from an unsaved Excel workbook into an Acess
table using Access VBA better manner than the 3 methods described below?
An Excel workbook was created from Access and a Webquery added and
refreshed. The data was then parsed (TextToColumns) but it could remain as
comma separated data if that makes it easier.
The Excel data could be read one row at a time and added to the table, but I
would rather not.
The data could be copied and a manual paste/append into the table, but I
would rather not.
The workbook could be saved allowing the use of TransferSpreadsheet. Then
kill the workbook.
|
Similar Threads
