Search results

Hi Everyone! I think I have asked this question before but I still do not have a solution for it. I have written a query to generate the report I want. I have also managed to export the query to excel(This export is done thru vba coding). However, I would like the the exported excel spreadsheet...

Please ignore my previous post. How would u run a delete query automatically. After the spreadsheet has been imported, then I need to run the delete query which then deletes the blank rows. Would be possible to run this automatically?

Hey Thanks for ur help.I tried what u suggested. However, the problem still persists. However, now the first part of excel spreadsheet is imported at the top and there are blank rows and the 2nd half of the excel spreadsheet is imported.:confused: Is there a solution to this ? :)

Sorry i just realised that even in the 2nd time, it does import .. However what happens is that the 2nd half of rows from the excel sheet is imported first and then there is quite a number of blank rows before the 1st half of the excel sheet is imported. However, I am quite keen that the excel...

Hey Thanks for taking your time to answer my question. Really appreciate it. I have now managed to partially solve my problem. Now I am able to import all the four columns like perfectly for the first time. However, when I try to import again, only very few rows are imported. Hope you can give...

Hey dbDamo.. the code u provided works well.. I tried it in a sample database and it works perfectly fine. However when I try to implement the same code in the project database, one of my column is cannot be imported properly. Just some details on my project. I am trying to import four columns...

Hey thanks for replying.. filter using a query? cos u see the excel data that I am importing does not really have column headings in the first row. it looks smthg like this xx xx xx xx xx xx...

Hello everyone. I am a newbie in access. I would actually like to import like only certain rows and columns from an excel file into a table into access. As the excel data would be changed dynamically, I have decided to use a linked table instead. Is it possible for the linked table just to...

Thank u very much for ur help. I will try to work on it! :)

hello everyone.. I have created reports in access and would need to export it to excel with proper formatting .. like for example the the font for the header shouldbe bold etc.. I have managed to export the files successfully by coding but I am not ableto do it with proper formatting. I am a...