Search results for query: *

Hi, How can I export the contents of a datagrid to an excel spreadsheet? I don't have a clue how to do this. Thanks, Dheeraj

Hi, I am using this code to import a .csv file selected by user ( the textbox Cmbhavfile holds the path for this file) to a table in Access but get an error: [Microsoft] [ODBC Text Driver] Syntax error in From Clause I don't understand what is wrong because the same code is running well on a...

Hi, Thanks William and CClint for your insights! I am now able to import a csv file to a table in Access. But the code that William has provided above, only allows the csv file specified by strCSV to be imported to a new table in the Access database. However I need it to work a little...

Hi, Thank you for responding william. I am new to VB and am not familiar with what you are talking about. I want to Import the CSV file to a table in Access. So I tried openning a connection to the database and using TransferText. What should I do to resolve this? Thanks, D

Hi, I am trying to import a CSV file using TransferText in VB. I am getting this error: Run Time Error: Object Required when I try to execute this code: Private Sub Next_Click() Dim cnn As New ADODB.Connection 'Open the Connection cnn.Open ("Provider=Microsoft.Jet.OLEDB.4.0;Data...

Hi, I am trying to import a dbase IV file into table in Access using the TransferDatabase command. I get this error: Run-time error: 91 Object Variable or With Block Variable not set. when I run this code: Private Sub Next_Click() Dim cnn As ADODB.Connection cnn.Open _...

AHA! So I don't get the "Object Required" error anymore. So you have star for that (I was so tired of seeing the same error... :) thanks!) But now we a different one. I get this error: Run-time error: 91 Object Variable or With Block Variable not set. when I run this code...

Thanks! I shrunk the .dbf file name to less than 8 characters and it worked. I am just wondering, why does i have to be a max of 8 chars to be imported while excel doesn't? anyway, thanks a lot. D

Thanks for the reply Patrick. Here is what I am trying to do. The path of the dBase IV file which is to be imported is in a textbox named 'Cmbhavfile'. I am using the following code to import te file into a table in the Access Database: Private Sub Next_Click() Dim cnn As New ADODB.Connection...

and yes, I am using Access 2000, VB 6 and Windows XP. D

Hi, I am having trouble importing a dBase IV file into Access through VB. The path of the dBase file which is to be tranferred is in a text box. I am trying to use the TransferDatabase Command but I get the following error: Object required What should I do to resolve this? Thank you, Dheeraj

Hi, Thanks for the lead. But I get this error when I try to use TransferDatabase: Object Required what should I do? D

Hi, Yes, the Import - Files of Type pick list includes dBase IV as a file type. I keep getting the same error, no matter what I try. I have Access 2000 with Windows XP. I hope that is not the problem. Thanks, D

Hi, Thanks! How do I export from dBase to either a text or excel file (in code)? Thanks, D

Hi, How I import dBase IV and Excel files into Access? I will really appreciate it if someone can give me the code for this. Thanks, Dheeraj

Hi, I get the following error when I try importing a dbASE IV file into Access: The Microsoft Jet Database Engine could not find the object 'filename'. Please make sure that the object exists and that you spell its name and path name correctly. What should I do to resolve this? I have been...

thanks! OK- here is a slightly different question. Suppose you want the user to select (eg. from a drop down menu) the file which is to be imported into a table in Access. What would be the code for this?

Hi, How can one dynamically link an excel file to access? I have an excel file that I need to update automatically at the end of the day. And then I need this updated file to be linked to an access database so that the database is updated dynamically. Any help will be appreciated. Thanks...

Hi Here's the dig: There is an excel file (day end stock prices) that is downloaded from the net. It needs to imported into access as a table. How does one setup an automatic update of the access table to correspond to the new excel file downloaded at the end of the day. Thank you, Dheeraj