Results 1 to 4 of 4

Thread: MS Access Data Types

  1. Oct 30th, 2017, 04:27 PM #1
    Zephaneas
    Zephaneas is offline

    Thread Starter
    Member
    Join Date
    Oct 2008
    Posts
    46

    MS Access Data Types

    Does anyone know of a reference for converting Access data types to .Net and MS SQL?

    Thank you
    Reply With Quote Reply With Quote
  2. Oct 30th, 2017, 06:12 PM #2
    jmcilhinney
    jmcilhinney is offline
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    110,347

    Re: MS Access Data Types

    What exactly are you trying to achieve? You should really need to do any explicit conversion if you're retrieving data into a .NET app. If you use a data adapter to populate a DataTable then everything will come out with the appropriate data type automatically.
    Why is my data not saved to my database? | MSDN Data Walkthroughs
    VBForums Database Development FAQ
    My CodeBank Submissions: VB (Sorting AlphaNumeric Strings Logically NEW, Binding a Data Reader in Windows Forms NEW) | C# (Sorting AlphaNumeric Strings Logically NEW, Binding a Data Reader in Windows Forms NEW)
    My Blog: Data Among Multiple Forms (3 parts)
    Beginner Tutorials: VB | C# | SQL
    Reply With Quote Reply With Quote
  3. Oct 31st, 2017, 09:50 AM #3
    Zephaneas
    Zephaneas is offline

    Thread Starter
    Member
    Join Date
    Oct 2008
    Posts
    46

    Re: MS Access Data Types

    I'm working on a tool that manages data from multiple sources. It can read in the structure of an Access table, the recreate it in SQL or other DBs.

    I have found some type conversion charts out there but I was wondering if there's something more definitive.
    Reply With Quote Reply With Quote
  4. Oct 31st, 2017, 10:12 AM #4
    szlamany
    szlamany is offline
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: MS Access Data Types

    Not sure what links you have found - here are a couple I've seen before

    https://docs.microsoft.com/en-us/dot...-type-mappings

    https://www.w3schools.com/asp/ado_datatypes.asp

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:     [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width