+ Reply to Thread
Results 1 to 5 of 5

Adodb Connection

  1. #1
    Forum Contributor
    Join Date
    04-09-2005
    Location
    Multan. Pakistan
    Posts
    129

    Adodb Connection

    Using Adodb connection to insert data in Excel sheet. All data saved in text format. Is there any way to save data in numeric format.

    Thanks

  2. #2
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,151

    Re: Adodb Connection

    e.g.:
    Please Login or Register  to view this content.
    For the data as below on image.
    Attached Images Attached Images

  3. #3
    Forum Contributor
    Join Date
    04-09-2005
    Location
    Multan. Pakistan
    Posts
    129

    Re: Adodb Connection

    Is there a way to insert data as values at the time of Entering data using adodb connection

  4. #4
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,151

    Re: Adodb Connection

    Try, but it's only an ersatz, because you didn't attach any example:
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    04-09-2005
    Location
    Multan. Pakistan
    Posts
    129

    Re: Adodb Connection

    What I did from Your Guidelines

    Code.jpg

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. ADODB Connection
    By kenny.fsw in forum Access Tables & Databases
    Replies: 12
    Last Post: 08-06-2015, 01:17 PM
  2. ADODB connection - Changing connection path via fileDialog
    By cajand in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-08-2015, 08:06 AM
  3. adodb connection quirks
    By vientito in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-15-2014, 10:51 AM
  4. VBA and ADODB.Connection
    By AedanLee in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-29-2010, 06:37 AM
  5. excel ADODB.connection to itself ? how?
    By djorkaef in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2010, 11:28 AM
  6. vb adodb connection passing value
    By jtwork in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-25-2008, 04:30 PM
  7. ADODB Connection String
    By Nigel C in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-20-2005, 03:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1