Import Data by looping?

C

chris

Good afternoon,

I have a question if someone could answer. I have Excel sheets, my
Access tables are set up the same way. My question is, with the click
of a button I would like to import this data by looping (While loop,
For loop, or Do-While loop)? That way all of the data is consistent
within each record rather than, going through MS Access import
functions.

Thank you,

Christopher
Kabul
 
S

Steve Schapel

Christopher,

Can you explain in what way the data is inconsistent if you use a
TransferSpreadsheet method from within Access?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro loop until end of file 2
WORD VBA Search and switch to advanced ... 1
Loop Limits Question 7
Loop from left to the right 5
loop until empty row and column problem (format cells until the lastrow and column in a report) 4
importing data 0
Please help me choose a product for the task 2
Loop returns only one value, does not loop & an assignment to columnhow-to problem. 26

Top