Hello world (1 Viewer)

T

TMBIT

New member

Local time

Today, 15:41

Joined

May 20, 2019

Messages

5

• May 20, 2019

• #1

Hey all. Amateur hobbyist here, on this forum for work. We're migrating our organization contact information and inventory control from our current separate, unorganized, numerous excel documents to a unified MS access database. As the de facto tech person in the office, I have been tasked with designing this database from the ground up. I'm definitely going to need all the help I can get. I've been lurking for the past 6 months and the archive threads have already solved several of my issues, so thanks!

TMBIT
USA

 

theDBguy

I’m here to help

Staff member

Local time

Today, 15:41

Joined

Oct 29, 2018

Messages

21,454

• May 20, 2019

• #2

Hi. Welcome to the forum!

 

Uncle Gizmo

Nifty Access Guy

Staff member

Local time

Today, 23:41

Joined

Jul 9, 2003

Messages

16,273

• May 20, 2019

• #3

TMBIT said:

We're migrating our organization contact information and inventory control from our current separate, unorganized, numerous excel documents to a unified MS access database.

Click to expand...

Hi TMBIT, welcome to Access World Forums (AWF)...

There is a major problem you can (WILL) run into importing Excel data into MS Access, I describe it in my blog here:-

http://www.niftyaccess.com/excel-in-access/

I also provide a tool for modifying your Excel data into a format suitable for MS Access.

I strongly recommend that you read up on this problem, as if you nip it in the bud right at the beginning, it's plain sailing but if you ignore it, it will eventually bite you in the proverbial!

Cheers Tony...

 

The_Doc_Man

Immoderate Moderator

Staff member

Local time

Today, 17:41

Joined

Feb 28, 2001

Messages

27,147

• May 20, 2019

• #4

Welcome, TMBIT. Regardless of why you are here, we are glad to add another voice to the chorus - or the chaos, as applicable.

 

T

TMBIT

New member

Local time

Today, 15:41

Joined

May 20, 2019

Messages

5

• May 20, 2019

• #5

Uncle Gizmo said:

I strongly recommend that you read up on this problem, as if you nip it in the bud right at the beginning, it's plain sailing but if you ignore it, it will eventually bite you in the proverbial!

Click to expand...

Thanks UG! I've actually watched several of your youtube vids before and found them very helpful on my Access journey so far.

I'll be posting in some of the help sections soon, as my current developmental roadblock is something I'll definitely be seeking outside input on.