Export and Import from excel with form in access

[waqas]

hi june7



before this file extention was .accdb now i save it in .mdb
i am using 2007access. i want to use this code in 2007.
i have more questions.

1. how can i use in code "refresh all".
2. how can i overwrite data by importing if its existing before in same date.

[June7]

1. Google: refresh requery
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

2. Delete all the records first then append all new set to table
DoCmd.RunSQL "DELETE FROM tablename"
or delete with WHERE clause to remove selected records.

You still haven't responded to my questions about error message and debugging. I am reluctant to assist if you have not made effort to solve.

[waqas]

HI june7

i tried to debug also but i could not find any thing.

i have attached before table form and module now you can also check.

[June7]

What do you mean, did not find anything? Was there an error message? Did the procedure run to end without error message but no import took place? Did the code divert to the error handler? What was the error code? Step debugging will provide answers. That means running the code one line at a time. Or comment out the On Error GoTo line so the debug will stop and highlight the bugging line.

[waqas]

hi june7

on this line of code error appear

If rstRead.BOF And rstRead.EOF Then
strMsg = "The import spec was not found. Cannot continue."
'MsgBox strMsg, vbExclamation, "Error"

i tell you i am new in access programing before i am using excel macro
now i have move to access may be my some question are like child question.

dont mind only cooperate with me i always busy on my job i get little time to study but i want to improve myself. i do self study only online my working hrs 12 hrs 2 hrs spend coming and going 2 hrs cutting,cooking and eating prepare myself like uniform washing etc..
2 hrs for study rest for sleep.

[June7]

We are all busy and most of us responding here are volunteers, not staff of the forum. Most of us are like you, using Access as part of trying to do a job but are not professional programmers.

WHAT IS THE ERROR MESSAGE?

BOF means Beginning of File and EOF means End of File. The recordset is either at the BOF or EOF or somewhere in between. Change the And to Or. Run the code again. Does it still error or do what you want? This is debugging and a process you need to learn and use to be an effective programmer. If you want to use code, need to understand it. If you don't have basic knowledge of programming concepts then you will be frustrated in efforts.

I finally got a minute to download your project. I was surprised to find code I would not have expected from a beginner (such as getting the file path for the project). Makes me wonder why you were not already familiar with debugging techniques.

I tried running your code and it locks up Access and have to kill it with Task Manager. You have a lot of debugging effort to do. Actually, think the BOF Or EOF test will never work. Use If rstRead.RecordCount = 0 instead.

Your project does not include all tables needed by the code. The code is opening a recordset on table ImportColumnSpecs which is not in the project. How can anyone test your code?

[waqas]

thanks june7

i learned every thing online by selfstudy i did not use before debugging techniques.
how can i use it?

[waqas]

june7

hurray i got it.
it is working now.

thanks for assisstance.