Getting records from excel into Access??? is it that annoyinnnnnngggg
-
Hello all, Am trying to create a function in access to get records from an excel file from sheet1 save it to one table im access(both 2007) , .... , unbeleivable ... cant find any hint on the net .... all doing the opposite (exporting to excel) :mad: its driving crazy ..... :wtf: any body can help??? Regards,,,,,
0 will always beats the 1.
-
Hello all, Am trying to create a function in access to get records from an excel file from sheet1 save it to one table im access(both 2007) , .... , unbeleivable ... cant find any hint on the net .... all doing the opposite (exporting to excel) :mad: its driving crazy ..... :wtf: any body can help??? Regards,,,,,
0 will always beats the 1.
-
Thanks Man, But honestly non of the search results gave a clear solution ... :( my problem is ,or the missing link in my issue is how to make my defined objects to be the represent an excel sheet on my drive. ie: Dim xapp Dim xworkb Dim xworks Set xapp= CreateObject("Excel.Application") this will create an excel object which i dont need. also Set xapp= Excel.Application Set xworkb= xapp.Workbooks.Open(1) this is wrong i think ?? how to set those variables to represent an excel sheet on C:\book1.xlsx so i can manipulate the data and transfer it to recordset then to my table . Helpppp
0 will always beats the 1.
-
Hello all, Am trying to create a function in access to get records from an excel file from sheet1 save it to one table im access(both 2007) , .... , unbeleivable ... cant find any hint on the net .... all doing the opposite (exporting to excel) :mad: its driving crazy ..... :wtf: any body can help??? Regards,,,,,
0 will always beats the 1.
scorp_scorp wrote:
unbeleivable ... cant find any hint on the net
Did you try to search with this query on google?[^]
I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com
-
scorp_scorp wrote:
unbeleivable ... cant find any hint on the net
Did you try to search with this query on google?[^]
I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com
yeah sure ... nothing expected ... most how to export from DB to excel .... and the next giving how to create new excel . some uses: DoCmd.TransferSpreadsheet which is usless for me, since i need to idendity the excel sheet as an abject and to do some calculations on records before dumping it in the table .
0 will always beats the 1.
-
Thanks Man, But honestly non of the search results gave a clear solution ... :( my problem is ,or the missing link in my issue is how to make my defined objects to be the represent an excel sheet on my drive. ie: Dim xapp Dim xworkb Dim xworks Set xapp= CreateObject("Excel.Application") this will create an excel object which i dont need. also Set xapp= Excel.Application Set xworkb= xapp.Workbooks.Open(1) this is wrong i think ?? how to set those variables to represent an excel sheet on C:\book1.xlsx so i can manipulate the data and transfer it to recordset then to my table . Helpppp
0 will always beats the 1.
This looks like more of an Excel VBA question rather than a database question. You might get a better answer if you post on the Visual Basic forum, if you have not done so already.
-
Hello all, Am trying to create a function in access to get records from an excel file from sheet1 save it to one table im access(both 2007) , .... , unbeleivable ... cant find any hint on the net .... all doing the opposite (exporting to excel) :mad: its driving crazy ..... :wtf: any body can help??? Regards,,,,,
0 will always beats the 1.
-
Hello all, Am trying to create a function in access to get records from an excel file from sheet1 save it to one table im access(both 2007) , .... , unbeleivable ... cant find any hint on the net .... all doing the opposite (exporting to excel) :mad: its driving crazy ..... :wtf: any body can help??? Regards,,,,,
0 will always beats the 1.
You're making things difficult for yourself. I simply use ADO.net. There is a .net connector for both Excel and Access -- I make a connection to each, query from one, and write to the other. Slick as snot.
-
You're making things difficult for yourself. I simply use ADO.net. There is a .net connector for both Excel and Access -- I make a connection to each, query from one, and write to the other. Slick as snot.
Am not that good in coding, but,
PIEBALDconsult wrote:
I simply use ADO.net.
suggest that am using an interface coding application or language (like .net), but am using VBA. does the ".net connector " exist in VBA ?? is there such a connector in VBA ??? Regards.
0 will always beats the 1.
-
Thanks Richard, but am not familiar with C# honestly, ... also , reading from excel that i create , i think is bit easy , but my excel sheet is alreacy exist , all i need is to - if i can say - pass this particular excel sheet to a function, in whcih it will read and manipulate. Any article for same topic in VBA ???? Regards,
0 will always beats the 1.
-
Am not that good in coding, but,
PIEBALDconsult wrote:
I simply use ADO.net.
suggest that am using an interface coding application or language (like .net), but am using VBA. does the ".net connector " exist in VBA ?? is there such a connector in VBA ??? Regards.
0 will always beats the 1.
Well, then this would be an excellent opportunity to improve yourself. Yes, I recommend using C# to write a simple command-line utility to do it. I wrote one just a few weeks ago to do just such a thing. There's really not much to it; the tricky part is in making it flexible so you can easily use it for other similar tasks in the future, but you can forego that for now.
-
Well, then this would be an excellent opportunity to improve yourself. Yes, I recommend using C# to write a simple command-line utility to do it. I wrote one just a few weeks ago to do just such a thing. There's really not much to it; the tricky part is in making it flexible so you can easily use it for other similar tasks in the future, but you can forego that for now.
Thanks for the support PIEBALDconsult...:thumbsup: But am now in middle of this application (Access DB, VBA, forms) am not sure that frezzing it at this stage and jump to starting it again (writting the interface) using C# . time is a bit tight... :( may be when i finish it, ill re-do it again in C# so i can build some skills using C#.
0 will always beats the 1.
-
Thanks Richard, but am not familiar with C# honestly, ... also , reading from excel that i create , i think is bit easy , but my excel sheet is alreacy exist , all i need is to - if i can say - pass this particular excel sheet to a function, in whcih it will read and manipulate. Any article for same topic in VBA ???? Regards,
0 will always beats the 1.
scorp_scorp wrote:
Any article for same topic in VBA
I don't know of any, or whether it is possible to write to Access from VBA. Try a Google search and see what you can find; I know there are a number of specialist Excel technical forums around.
I must get a clever new signature for 2011.
-
Hello all, Am trying to create a function in access to get records from an excel file from sheet1 save it to one table im access(both 2007) , .... , unbeleivable ... cant find any hint on the net .... all doing the opposite (exporting to excel) :mad: its driving crazy ..... :wtf: any body can help??? Regards,,,,,
0 will always beats the 1.
I came across the same problem and I wrote up a little VBA code in ACCESS handle this. It is still in the beta phase and I am still pretty week in the code formating and documenting code, but the functionality is all there. So far it has the following features: - File Folder Scanning and Keyword Search - Batch excel file scanning - Semi-Automatic ACCESS database creater from EXCEL. - Data Viewer with column order, and sizing - ACCESS data filter - Export to excel based on the ACCESS data filter. Again it is in the beta phase. Email me at david.lario@ualberta.net if you want me to forward what I have to you. If there is enough interest I could try post the routine to the code project.