Excel or Access

[Guest]

Hello,

I have this download from a General Ledger System. I created a database
that reviews this data and reports it.

I have one question. On my data download the data has an account number as
XXXXX00111.

In excel I set up formulas to seperate the data and combine it to
XXXXX-00-111.

Is there a way to do this in access to make an easy download.

 

[Guest]

All you really have to do for this is to create an input mask. If you've
already got all of the information from your access database, into excel, to
make it seperate things as you like, then it'd probably be easiest just to
import the data into access from Excel.

After you have your table setup, you can go into the field you want to apply
that data formatting to, and go to input mask. Next to it click the "..."
button, then you go to Edit List, and create a new input mask type... Just
make sure you test it, thought judging from your post, your input mask would
probably end up looking like:

#####-##-### (If your X's appear as numbers, if they are actually X's try
XXXXX-##-###).

Hope this helps.

 

[Joseph Meehan]

Hello,

I have this download from a General Ledger System. I created a
database that reviews this data and reports it.

I have one question. On my data download the data has an account
number as XXXXX00111.

In excel I set up formulas to seperate the data and combine it to
XXXXX-00-111.

Is there a way to do this in access to make an easy download.

I am not sure exactly want you want to do add or delete the "-" or
exactly where. That is is the data coming in with or without the -? Is the
data going out of your file with or without the -? How is it to be stored
in the database (three fields, one field with "-" or on field without "-"?

In short the answer is yes, Access can handle it any number of ways. I
suggest that how you store it in access is dependent on the data, how
consistent it is (always the same number of characters in each of the three
groups?) any order (like ascending numbers) etc and how it is to be used.

More information will be needed for concrete suggestions.