Search:

Hi,

Just needing your help where can i find best tutorial link about creating query codes for Visual C#.net and making it into graphs/ chart form.

Thank You.

Thanks a lot for the reply.

I had tried it already the only problem I have if my table containing around 50++ fields.

I want my criteria to be flexible like no matter how many columns of two...

Hi,

Just want to ask how to compare to identical table in MS Access and identified the unmatched data inside.

Example
TABLE1:

STUDENTId TELNO COURSE
1 111 ME
2 ...

Hi,

Do you have some source code how to open a file (file browser) with file extension specific using Visual basic.net.

Just need to get the path then control this using the vb.net binding
...

Hi,
Does anybody can give me tutorial link how to convert excel data and move it to txt file? Source code will be highly appreciated.

Thanks thanks.

Hi,

Does anyone have a source code or tutorial link how will I able to convert and Excel File data into an XML file?

Currently I have tables that compose of headers and Data from excel file and...

Hi,

If anyone can help me for any good link in website that will teach me from the bottom how to link ms sql in Visual basic.net and display data records in graphical representation.

Thanks.

Hi,

In our company we are using PHP to display graph from statistics in SQL over webpage.
So anywhere just access the website and input the date will display statistics over the webpage of the...

Hi,

ADO code working very fine with me. The only thing now I want to automate using VBA in Access is the step1 you mentioned. (Copy paste sheet 1 to another sheet). Reason is my data actually...

Hi,

Here is the 2 excel file containing 2 sheets (TABLE1,TABLE2) that I want to merge all data into MS access with the same format at TABLE1 and TABLE2 at MS access.

So meaning the sheet...

Hi,

Can anyone possibly help me how can I do in VBA MS access the action of merging data of 1st excel data sheet and 2nd excel sheet and putting it into single table only.

Actually I have to...

HI,

IN my attached excel file the value i got is "27:42.8" which is equivalent to 12:27:43 PM.. the actual value in seconds is 42.8.

Actually i want to get the value of seconds and move it in...

HI,

Im having some difficulties in getting the exact value of time in VBA.

in my example attached, i have time:
(HH:MM:SS)
24:44:4 and
24:44:6

If i use the excel sheet formula it gives me...

HI,

Is it possible to open a txt file or any kind of file in MS excel Application using MS access VBA and text to column (comma delimited) the file I opened?


Thanks.

Ive done the code below:


DoCmd.TransferText acImportDelim, aa, "Import", strFiles, False

Only this will work once I change the file extension of my file "sample.log" into *.txt.

Is there a...

thanks for the nice answer!!! really helpful

Hi,

I have a file having an file extension of *.log, usually I can read the content file one by one using:


strFiles$ =...

HI,

Does anybody know how to export text file to MS access faster that will start in certain line of txt file?

Thanks. Im using VB.net 2008....

If you can remember the link I will highly appreciate..

I have SQL server 2008 setup already.. and I want my VB.net to do the graph display on it... I will give...

Hi,

Does anyone can give me some link related to tutorial of graphical display using asp.net where my data coming from SQL database?

Thanks.

Hi,

I created some database already in my SQL server 2008. And im planning to show all this data via graph using VB.net...

Is there anyone here can give me LINK, thread or the best is tutorial...

Hi,

Does anyone know sample code to skip the step procedure of Linking Table of SQL Database into MS access?

My front-end is MS Access 07 and I created ODBC Data Source for my SQL SERVER 2008...

Thanks. I already done it!!!

:check:

HI,

Ive been using my SQL server 2008 express edition already in my computer. How come when Im starting to create ODBC link, the SQL server doesn' appear at all? Normally should detected right?
...

Hi,

Just want to know is somebody know how to create step by step procedure in creating ODBC connection on SQL server.

ACtually I set-up an SQL server in centralized PC already. And i want the...

Sorry I mean ADO.net.. Im using VB.net express edition but i cant find in the choices..

Hi,
Does anybody know how to add reference of ADO in VS.net 2008?
seems i cant find it in add reference inside.

How about using Use ADO and SQLOLEDB?

have any sample code?

Hi Rob,

Im using SQL Server 2008 Express Edition only. Is this applicable to the one I have too?

with this setting How I manage to select the right excel sheet to the right SQL table?

Thanks.

Hi,

Is anyone here have some sample code of opening and selecting a certain excel file and append the data of the exact excel sheet in one of my SQL server table?

Im using VB2008 express...

Hi,

Does anyone has a sample code that do like,

Open and select excel file and select the exact excel sheet to import then connect to SQL server 2008 and append all the data from the certain...

For the one you mentioned, connection string... where, will I do this inside my SQL server?

From your link given to me at http://support.microsoft.com/kb/321686,
I saw below there is sample for...

COLUMN : A:IK
ROWS: INDEFINITE(depends how many days is the stats)

Hope you can help me with this...

my data from excel to be transferred/import to sql server containing date.

So every day its a unique stats based on date. I want to secure also that if someone update the SQL server it will check...

Hi,

Does anybody know how to update the data of an SQL server 2008 express using vb.net 2008? My raw data actually from excel file only and i want to transfer all the data and merge it in my newly...

ok thanks for reminders

This one wont work since this need the file "C:\Folder\File.txt" to exist else it will error.

I will create many txt fiel based on my loop. meaning unpredictable txt file. Maybe 3 txt or more.
...

thanks done it already.

Hi,

I just having some problem with my codes on access 2007.....

My code in VBA access 2003:


DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, _
"TABLE", strfiles,...

Normally I perfrom inside my code:


sSQL = SELECT * FROm TABLE NAME;

Then i use:


db.OpenRecordset(sSQL)